Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Horizontal data to vertical data
I have a set of data list in the horizontal manner. Is there a macro that
can send this data vertically instead of manually doing it? Thanks in advance. Aloysicus |
#2
|
|||
|
|||
You can do what you are asking by:
1)Select the horizontal range of cells. 2)EditCopy 3)Select the cell where you want the vertical list to start. 4)EditPaste Special 5)Check the TRANSPOSE box and click [OK] List horizontal list will be copied into a vertical list. Is that what you're looking for? Regards, Ron |
#3
|
|||
|
|||
Here's one way as responded to your identical post in .newusers
(please do not multi-post) Assume source data is in Sheet1, A1:E1 In Sheet2 Put in A1: =OFFSET(Sheet1!$A$1,COLUMNS($A$1:A1)-1,ROWS($A$1:A1)-1) Copy A1 down by as many rows as there are columns in Sheet1, i.e. down to A5 A1:A5 will return whats in A1:E1 in Sheet1 -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Aloysicus" wrote in message ... I have a set of data list in the horizontal manner. Is there a macro that can send this data vertically instead of manually doing it? Thanks in advance. Aloysicus |
#4
|
|||
|
|||
Accidentally posted another in .newusers....did not mean to do it....
Thanks for your help, Max "Max" wrote in message ... Here's one way as responded to your identical post in .newusers (please do not multi-post) Assume source data is in Sheet1, A1:E1 In Sheet2 Put in A1: =OFFSET(Sheet1!$A$1,COLUMNS($A$1:A1)-1,ROWS($A$1:A1)-1) Copy A1 down by as many rows as there are columns in Sheet1, i.e. down to A5 A1:A5 will return whats in A1:E1 in Sheet1 -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Aloysicus" wrote in message ... I have a set of data list in the horizontal manner. Is there a macro that can send this data vertically instead of manually doing it? Thanks in advance. Aloysicus |
#5
|
|||
|
|||
You're welcome !
Thanks for feedback .. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Aloysicus" wrote in message ... Accidentally posted another in .newusers....did not mean to do it.... Thanks for your help, Max |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel moving horizontal columns to vertical | Excel Discussion (Misc queries) | |||
tranfere vertical data to horizontal tabel | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Flip the X and Y data on a chart so that the Y data is vertical. | Charts and Charting in Excel | |||
How can I insert a vertical column break between data to create a. | Excel Worksheet Functions |