Transpose from row to column with spaces in between the rows

[fubini89]

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

[patel45]

why did you attach csv file ? you need to import it ?

[fubini89]

why did you attach csv file ? you need to import it ?

Wat u mean by importing. I imported into excel I can transpose it. I had to do it manually.

[fubini89]

Correction cant transpose it

[patel45]

attach please a sample file with initial data and desired result

[arlu1201]

patel,

Check post 1 for files.

[arlu1201]

fubini,

You need to tell us what data goes where. There are many columns in your xlsm file.

[fubini89]

Dear Patel45,

Here is original data
original.xls


And this how I want the data to look like
results.xls

Thanks again

[fubini89]

fubini,

You need to tell us what data goes where. There are many columns in your xlsm file.

Okay so the original data has, about 19 to 25 sets of 300 to 500 rows from column 1 to 4, each divided by blanks cells to show when a new set starts.
1) I need the entire column 4 to be deleted for all the sets.
2) Starting from set 2 (name is JJCEX. AHU.07. #number:DISCH STAT) I need the entire first column (name is point system) deleted all the way to last set.
3)Then after each blanks cells starting from set 1. I need it to be copy and pasted to new sets columns lining up with set 1.
I need code that will copy each set after a blank cell to new sets of columns.

Thanks