Hello,
I have a spreadsheet that is generated in a difficult format tomanipulate. A series of reports are generated in sequence in teh one worksheet. I wish to transpose some of the data from each report into a more useable format. Additionally the data is irregular, and sometimes contains field that I don't wish to be transposed.
Attached is an example spread sheet. The data on the left is the raw print out, and I wish to transpose some of thge data into the fields on the right. Can anyone help me achieve this?
Bookmarks