I have a set of data: example
Colum1 Column2 Column3 Column4
1 2 3 4
1 2 3 4
1 3 4 5


1 2 3 4
1 2 3 4
1 2 3 4

1 2 3 4
1 2 3 4
1 2 3 4

I need to transpose but the spaces in between the rows are causing trouble. How can I do this in macros. I attached the data also. AHU 06_05-06-13_13-59.csv

and need to look llike this
AHU 06_05-06-13_13-59.new.xlsm
any help is great. Thank You