Hello and good morning.

I have a spreadsheet which is basically a long list of records in column A. It is pretty much blocks of data. The blocks are separated by a single blank row. Each block contains either 7 or 8 lines. It varies throughout.

What I want to do is somehow do a transpose for each block of data. For example the last line in each block contains the word "Product Code" so it would be logical to tell Excel to transpose everything between the blank row, and the row which contains the word "Product Code".


Someone suggested I use a macro to transpose every Nth row but that won't work since the blocks are not uniform in the amount of rows they have, thus throwing a wrench in the gears.

Can someone help me out with this? Thank you.