Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data from rows into columns
I have data (names) in rows 1-7 (columns A-IV). Each cell contains a new name.
Can anyone suggest a quick & easy way to move the data all into colum A Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data from rows into columns
Have just found the answer using the MS Excel Help files;
Transpose rows and columns 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. Select the cells that you want to switch. Click Copy . Select the upper-left cell of the paste area. The paste area must be outside the copy area. Click the arrow to the right of Paste and then click Transpose. "Dave" wrote: I have data (names) in rows 1-7 (columns A-IV). Each cell contains a new name. Can anyone suggest a quick & easy way to move the data all into colum A Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to pivot my data from columns to rows | Excel Discussion (Misc queries) | |||
Arrange data spanning 8 columns and 3 rows to 24 columns and 1 row | Excel Discussion (Misc queries) | |||
Transfer data in columns to rows | Excel Discussion (Misc queries) | |||
Data from Rows into columns | Excel Discussion (Misc queries) | |||
Move Data from rows to columns... | Excel Worksheet Functions |