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


To this:

firstName lastName email title organization industry
joe smith (E-Mail Removed) Other ABC Org Energy & Resources
tom smith (E-Mail Removed) Other GCI Technology, Media &
Telecommunications

Any suggestions?

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 (E-Mail Removed)
> title Other
> organization ABC Org
> industry Energy & Resources
> firstName tom
> lastName smith
> email (E-Mail Removed)
> title Other
> organization GCI
> industry Technology, Media & Telecommunications
>
> To this:
>
> firstName lastName email title organization industry
> joe smith (E-Mail Removed) Other ABC Org Energy & Resources
> tom smith (E-Mail Removed) Other GCI Technology, Media &
> Telecommunications
>
> Any suggestions?

--

Dave Peterson