Menu

Help using Transpose

Search this Thread

Prev

Previous Post

Next Post

Next

#7

Report Post

Posted to microsoft.public.excel.programming

Dave Peterson Dave Peterson is offline

Dave Peterson is offline

external usenet poster

Posts: 35,218

Default

Help using Transpose

You have another reply at your other post.

wrote:

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

Doe, John
Lawyer
J&J LLC
123 Four Street, NY, NY 12345
(123)456-789

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 |
Row Two:
Doe, John | Lawyer | | J&J LLC | 123 Four Street, NY, NY 12345 |
(123)456-789 |

and so forth.

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

--

Dave Peterson

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need transpose? help....	Jethro Bodeene	Excel Worksheet Functions	9	March 17th 10 08:35 PM
Transpose from Col to row	Smiley	Excel Discussion (Misc queries)	4	January 15th 07 05:00 PM
Transpose from Col to row	Smiley	Excel Worksheet Functions	4	January 15th 07 05:00 PM
TRANSPOSE	Dave F	Excel Discussion (Misc queries)	1	August 17th 06 10:09 PM
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES	Umair Aslam	Excel Worksheet Functions	1	September 22nd 05 01:19 PM

All times are GMT +1. The time now is 12:59 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement