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
|
|||
|
|||
One way ..
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 |
#3
|
|||
|
|||
From Excel Help: Switch rows of cells to columns or columns to rows Data from the top row of the copy area appears in the left column of the paste area, and data from the left column appears in the top row. 1 Select the cells that you want to switch. 2 Click Copy . 3 Select the upper-left cell of the paste area. The paste area must be outside the copy area. 4 On the Edit menu, click Paste Special. Show me 5 Select the Transpose check box. -- cycling-rod |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Horizontal data to vertical data | 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 |