Help using Transpose

Giganews Newsgroups
Subject: Help using Transpose
Posted by:  vinhda…@gmail.com
Date: 26 May 2006

I need help with the transpose function. Currently I have 2000 columns
with data of people's names. For example

Jane Doe
Partner
J&J LLC
123 Four Street, NY, NY 12345
(123)456-789
Jad…@websitexyz.com

Doe, John
Lawyer
J&J LLC
123 Four Street, NY, NY 12345
(123)456-789
Jd…@websitexyz.com

I wish to transpose the data from a column to row with a delimiter
using that email address (because not all of the data has 6 rows of
data)

Is this possible without VisualBasic? Such as a function that will
notice the "@" symbol and transpose the next group of data into a new
row.

The output should be like this

Row One:
Jane Doe | Partner | J&J LLC | 123 Four Street, NY, NY 12345 |
(123)456-789 | Jad…@websitexyz.com
Row Two:
Doe, John | Lawyer | | J&J LLC | 123 Four Street, NY, NY 12345 |
(123)456-789 | Jod…@websitexyz.com

and so forth.

If you have any suggestions or websites I can check out, you have my
gratitude!

Replies