| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a horizontal list of text values
How can I create a horizontal list of text values from a vertical list. For
instance: Part 1 abc Part 1 def Part 1 ghi Part 2 abc Part 3 def Part 3 jkl I would like the above data to look like this (or something similar): Part 1 abc, def, ghi Part 2 def Part 3 def, jkl |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a horizontal list of text values
Try using paste special - transpose. This turns text from vertical to
horizontal and vice versa. "Kelly" wrote: How can I create a horizontal list of text values from a vertical list. For instance: Part 1 abc Part 1 def Part 1 ghi Part 2 abc Part 3 def Part 3 jkl I would like the above data to look like this (or something similar): Part 1 abc, def, ghi Part 2 def Part 3 def, jkl |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating list of names from specific value | Excel Discussion (Misc queries) | |||
| Creating a concatenate text list by referencing an array | Excel Discussion (Misc queries) | |||
| Link Protected WorkBook ... and Get #N/A for Text Values! | Excel Discussion (Misc queries) | |||
| Creating an invoice with a lookup list | Excel Discussion (Misc queries) | |||
| Text to Columns from drop down list update | Excel Discussion (Misc queries) | |||
Linear Mode
