|
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 |
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 |
| All times are GMT +1. The time now is 11:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com