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.

Michael wrote:

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
title Other
organization ABC Org
industry Energy & Resources
firstName tom
lastName smith
email
title Other
organization GCI
industry Technology, Media & Telecommunications

To this:

firstName lastName email title organization industry
joe smith Other ABC Org Energy & Resources
tom smith Other GCI Technology, Media &
Telecommunications

Any suggestions?

--

Dave Peterson