Macro to transpose to row after blank lines

[Gameiro]

Hi folks,

I have this piece of data with this layout:


000xxxx1 - CLIENTE 1 (code and name)
PRODUCT CODE | PRODUCT DESCRIPTION | QUANTITY SOLD | UNIT PRICE | SALES VALUE
Total - 000xxxx1 - CLIENTE 1 (code and name)
[white row]
[white row]
000xxxx2 - CLIENTE 2 (code and name)
PRODUCT CODE | PRODUCT DESCRIPTION | QUANTITY SOLD | UNIT PRICE | SALES VALUE
PRODUCT CODE | PRODUCT DESCRIPTION | QUANTITY SOLD | UNIT PRICE | SALES VALUE
PRODUCT CODE | PRODUCT DESCRIPTION | QUANTITY SOLD | UNIT PRICE | SALES VALUE
Total - 000xxxx2 - CLIENTE 2 (code and name)
[white row]
[white row]
000xxxx3 - CLIENTE 3 (code and name)
PRODUCT CODE | PRODUCT DESCRIPTION | QUANTITY SOLD | UNIT PRICE | SALES VALUE
PRODUCT CODE | PRODUCT DESCRIPTION | QUANTITY SOLD | UNIT PRICE | SALES VALUE
PRODUCT CODE | PRODUCT DESCRIPTION | QUANTITY SOLD | UNIT PRICE | SALES VALUE
PRODUCT CODE | PRODUCT DESCRIPTION | QUANTITY SOLD | UNIT PRICE | SALES VALUE
Total - 000xxxx3 - CLIENTE 3 (code and name)
[white row]
[white row]

and so on..

I need to transpose the client code and number to a column before the product code so I can pivot it (right?) and it would take a minutes if the data was not so big. The problem is that there are almost 30k lines of data and I was wondering if someone can sugest a macro to make it happen without me loosing a couple of days doing it manual. One nice thing is that the report is breaked with 2 empty lines after each client data (as I think that can be usefull). Ideally the total line after each client data would be deleted too.

Any help on this?

Thanks in advance and congrats on great community, I've already learned a lot with you guys