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?