Combining multiple rows with duplicate info -- help!

[Michael]

All,

Is there any way to capture this data and consolidate the headers in
Excel 2007. I would like to go from this:

firstName joe
lastName smith
email (e-mail address removed)
title Other
organization ABC Org
industry Energy & Resources
firstName tom
lastName smith
email (e-mail address removed)
title Other
organization GCI
industry Technology, Media & Telecommunications


To this:

firstName lastName email title organization industry
joe smith (e-mail address removed) Other ABC Org Energy & Resources
tom smith (e-mail address removed) Other GCI Technology, Media &
Telecommunications

Any suggestions?

 

[Dave Peterson]

This suggestion has lots of assumptions--if your data varies from those
assumptions, you'll want to share a more detailed description of the data
layout.

I'm assuming that column A contains those labels. Column B contains the data to
use. There are always 6 labels per entry--and they're always in the same order.

If all that's true, then put this in C1:
=INDEX($B:$B,(6*(ROW()-1))+(COLUMN()-2))
And drag across to column H

Then select C1:H1 and drag down as far as you need--you'll see 0's if you go too
far.

Then convert all your formulas to values, delete columns A:B and add headers to
your data.