spudmcc
asked on
Column header into Column data
Hello Experts!
Have another challenge that I am hoping you might be able to help me with today.
We have large spreadsheets that have headers then the data, then another header then more data and on and on. What I need to do is to take the header on top of that group of data and bring it over to a column and fill down. You can see this easily in the example I attached to this post. The row numbers are not constant and the amount of data under each header fluxuates.
Any help would be greatly appreciated.
Andy (spudmcc)
Example.xls
Have another challenge that I am hoping you might be able to help me with today.
We have large spreadsheets that have headers then the data, then another header then more data and on and on. What I need to do is to take the header on top of that group of data and bring it over to a column and fill down. You can see this easily in the example I attached to this post. The row numbers are not constant and the amount of data under each header fluxuates.
Any help would be greatly appreciated.
Andy (spudmcc)
Example.xls
does the first header always fall on the same row?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect! Thanks so much for the very quick turnaround and the super simple answer.
I very much appreciate the help as always.
Andy
I very much appreciate the help as always.
Andy