| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Many Columns to Many Rows
How do I "copy / paste" many _columns_ of values to many _rows_? In other words, how do I take a string of values across a worksheet and put them in one column? Small example ... Would like to take values in A1, B1 and C1 and put them in A2, A3, A4. Thanks. -- Cecil ------------------------------------------------------------------------ Cecil's Profile: http://www.excelforum.com/member.php...o&userid=29035 View this thread: http://www.excelforum.com/showthread...hreadid=514050 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Many Columns to Many Rows
select A1 to C1
cntrl C to copy the range select A2 edit......... paste special.......tick "transpose" -- Greetings from New Zealand Bill K "Cecil" wrote in message ... How do I "copy / paste" many _columns_ of values to many _rows_? In other words, how do I take a string of values across a worksheet and put them in one column? Small example ... Would like to take values in A1, B1 and C1 and put them in A2, A3, A4. Thanks. -- Cecil ------------------------------------------------------------------------ Cecil's Profile: http://www.excelforum.com/member.php...o&userid=29035 View this thread: http://www.excelforum.com/showthread...hreadid=514050 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Many Columns to Many Rows
Cecil, select your data then Copy, select A2, Paste Special, Transpose.
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Cecil" wrote in message ... How do I "copy / paste" many _columns_ of values to many _rows_? In other words, how do I take a string of values across a worksheet and put them in one column? Small example ... Would like to take values in A1, B1 and C1 and put them in A2, A3, A4. Thanks. -- Cecil ------------------------------------------------------------------------ Cecil's Profile: http://www.excelforum.com/member.php...o&userid=29035 View this thread: http://www.excelforum.com/showthread...hreadid=514050 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Many Columns to Many Rows
Hello Bill, Paul Thanks for the tip. That was "too easy" ... I shouldn't have missed that one  Regards, Cecil.-- Cecil ------------------------------------------------------------------------ Cecil's Profile: http://www.excelforum.com/member.php...o&userid=29035 View this thread: http://www.excelforum.com/showthread...hreadid=514050 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rows & Columns in Excel | Excel Worksheet Functions | |||
| convert columns to rows & rows to columns | Excel Discussion (Misc queries) | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
| hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Linear Mode
