Macro to sort merged data

Hi,

I have a data set which has two cycles merged toether first 20 rows are from one set, while the next 15 rows are from different data set. This is repeated for couple of thousand rows. The column 1 shows jumps at regular order as per above description. Is there a logical way to sort them into different data sets. Test.csv

Start a loop counter at row 2 and increment by 35 (rows). Then copy base address, resized by 20 rows, to a new column or new sheet. Copy base address plus 20, resized by 15 rows to a different new column or sheet.

Should be relatively straightforward.