Column header into Column data

spudmcc
spudmcc used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
does the first header always fall on the same row?
Enter this in A3 and then copy down

=IF(FIND("-",B3&"-")>LEN(B3),"",IF(FIND("-",B2&"-")>LEN(B2),B2,A2))

Author

Commented:
Perfect!  Thanks so much for the very quick turnaround and the super simple answer.  
I very much appreciate the help as always.


Andy

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial