I have an excel file with about 300+ columns. Each column has a different number of rows.
Each column has a header row with number assigned to it 1-300+
I need a second column made to the left of each current column.
The end output will be just 2 columns. The left column has the numbers and the right column has the rows with corresponding numbers.
At the end I want you to tell me how you did this.
Attached is the data. Lowest bid wins, and if you can have a file done and waiting for me I will probably pick your bid first.
File data1.xls has the data that I want you to transpose.
File Example output.xls is an example using the first two columns in Data1.xms. This is how I want the data to be output.
Thanks.
