Please, I need some help to transpose data from 6 columns to 6 lines.
See attached file:
data blocks to transpose.xls
This is just a small part of the data.
The data is in blocks along 6 columns separated by 1 empty line.
So, it must be transposed to 6 lines and the number of columns varies.
And keeping separed by 1 line.
There's something almost like this in:
http://www.ozgrid.com/forum/showthread.php?t=83008
http://www.mrexcel.com/forum/excel-q...osed-rows.html
I have tried this and another code but still didn't work.
I would reaaaaaally appreciate some help!
Bookmarks