Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move Column data to rows
Hi Sirs and Madams I have a list of roughly a thousand numbers in one column, I would lik to know how to take those numbers and put them into one row and column with only a comma seperating them. e.g. 17205 17206 17207 17216 17218 17219 17221 17225 -- 17205,17206,17207,17216,17218,17219,17221,17225 Thank you Kind Regard -- popp ----------------------------------------------------------------------- poppy's Profile: http://www.excelforum.com/member.php...fo&userid=1145 View this thread: http://www.excelforum.com/showthread.php?threadid=49145 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move Column data to rows
This may get you started. Select the range of numbers before running this
and change the output cell from B1 to your cell. Sub a() Dim ValStr As String Dim Cell As Range For Each Cell In Selection ValStr = ValStr & Cell.Value & "," Next ValStr = Left(ValStr, Len(ValStr) - 1) Range("B1").Value = ValStr End Sub -- Jim "poppy" wrote in message ... | | Hi Sirs and Madams | | I have a list of roughly a thousand numbers in one column, I would like | to know how to take those numbers and put them into one row and column | with only a comma seperating them. | | e.g. | | 17205 | 17206 | 17207 | 17216 | 17218 | 17219 | 17221 | 17225 | | -- 17205,17206,17207,17216,17218,17219,17221,17225 | | Thank you | | Kind Regards | | | -- | poppy | ------------------------------------------------------------------------ | poppy's Profile: http://www.excelforum.com/member.php...o&userid=11453 | View this thread: http://www.excelforum.com/showthread...hreadid=491450 | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move Column data to rows
Hi Jim Thank you very much Kind Regard -- popp ----------------------------------------------------------------------- poppy's Profile: http://www.excelforum.com/member.php...fo&userid=1145 View this thread: http://www.excelforum.com/showthread.php?threadid=49145 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
name,address in same column different rows. How move to columns | Charts and Charting in Excel | |||
Move a Column to rows | Excel Discussion (Misc queries) | |||
How can I move to another cell two rows up and 1 column over in VB | Excel Programming | |||
Need a macro to move data from column into rows | Excel Programming | |||
Move data from different columns into one column, but different rows. | Excel Programming |