Data cleaning for data spread over multiple rows and columns

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)

In your example, you can derive 3 tables and then process each block of data points in respective derived table. See example below:

excel-cropping.morph (5.8 KB)

1 Like