Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rows and columns
how do I quickly convert rows to columns
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rows and columns
If you mean "row data" into "columnar data", highlight the row of data,
select COPY, click on the target cell then EDIT PASTE SPECIAL Transpose OK. -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "upolu" wrote: how do I quickly convert rows to columns |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rows and columns
Hi,
If you data is in range C5:C9 and you want to transpose this to F5:J5, you can use the transpose() array formula. Highlight F5:J5 and type =transpose(C5:C9) and now press Ctrl+Shift+Enter. Hope this helps. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "upolu" wrote in message ... how do I quickly convert rows to columns |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rows and columns
Hi,
You can also use a combination of some of the following functions: OFFSET, INDEX, INDIRECT. But details would depend on details of your data. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "upolu" wrote: how do I quickly convert rows to columns |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i paste rows/columns avoiding hidden rows/columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) |