Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I transpose entries that repeat in sequence down a column .
I am trying to transpose a bunch of data that is repeated ad nauseam down a
column (lets say Column A) and I want to separate the entries so that they appear listed by column: Example: Change this data Bob Smith Name 3 Smith Street Address 03-9898-1214 Phone Jane Doe Name 4 Big Avenue Address 03-9898-1215 Phone Into This Data Name Address Phone Bob Smith 3 Smith Street 03-9898-1214 Jane Doe 4 Big Avenue 03-9898-1215 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I transpose entries that repeat in sequence down a column .
http://tinyurl.com/6j9nz
-- Regards, Tom Ogilvy "Anzacdave" wrote in message ... I am trying to transpose a bunch of data that is repeated ad nauseam down a column (lets say Column A) and I want to separate the entries so that they appear listed by column: Example: Change this data Bob Smith Name 3 Smith Street Address 03-9898-1214 Phone Jane Doe Name 4 Big Avenue Address 03-9898-1215 Phone Into This Data Name Address Phone Bob Smith 3 Smith Street 03-9898-1214 Jane Doe 4 Big Avenue 03-9898-1215 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setting up sequence sets with only 3 repeat once in excel | Excel Worksheet Functions | |||
Highlight repeat entries | Excel Discussion (Misc queries) | |||
Can excel Flag repeat entries? | Excel Discussion (Misc queries) | |||
Searching a list with repeat entries and creating a sum | Excel Discussion (Misc queries) | |||
Repeat Entries | Excel Programming |