Easy Transpose Macro

[ebdmbfan]

Hi,

I figure this has been done before but in complex terms, so I will try to make this request simple.

I have rows of invoice data not including headers. Then I have columns of data within those invoices. I want the headers, row 1, to be in the 1st column. Then want the invoice data, which is currently in row format to move to column format. For example row 2, my first invoice, data should be in column 2 matching with the header column that was moved from row 1 to column 1. Row 3, my second invoice, data should be throughout column 3. Attached is a sample.

Thank you!

[Jakobshavn]

Transpose from Sheet1 to Sheet2:

Please Login or Register  to view this content.

This is so the original data will not be over-written

[ebdmbfan]

Great, thank you very much, works perfectly.