Transpose data blocks from 6 columns to 6 lines

[dualaudio454252]

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!

[jindon]

Try

Please Login or Register  to view this content.

[dualaudio454252]

It works perfectly!
You're awesome, Jindon!
Thank you very, very much!