Hi community,
Not sure if somebody has already raised this query before as could not find anything basis search i used.
So a lot of times I receive data in multiple files that is symmetrical , there would be data in first 4 columns spread over 5 rows and then 10 rows below there would be 5X5 data. there would be another data 5 columns away.
Is there any way to clean up such data and create symmetrical data?
I am attaching files for referenceseparateddata test.morph (3.1 KB) separateddata test.xlsx (8.2 KB)