Thread: How do I re-organize the following data into simple columns?

Hi there,

I am not sure how to do this, please take a look at the attachment image for the data spreadsheet I have.

I want to automatically reorganize the data into simple columns and headers.

eg. "name" in column 1 and "email" in column 2 , and then somehow have the all names (formatted like in the picture) under the name column.

all the spacing are equal in the "business card" like format, not sure if that helps.

please give me some advice!

<please see third post for actual xls example>

thanks!

You're more likely to get a response if you post in the most appropriate forum - I've moved this from Word Forum to Excel Functions Forum.

Posting a sample file is also likely to speed up the process of getting a resolution - remove anything confidential.