| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I move data in prexisting rows to columns?
I have ranges of data in rows. I want to arrange the data in columns. How do
I go about it? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I move data in prexisting rows to columns?
darryl wrote: I have ranges of data in rows. I want to arrange the data in columns. How do I go about it? Hi Darryl, Maybe you can use the Transpose option under Paste Special. Select your data - Edit - Copy. Then select where you want your data and go to Edit - Paste Special and tjeckmark Transpose and press OK. Regards, Bondi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import data and keep duplicate rows of data | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Dealing with data in several columns AND rows | Excel Discussion (Misc queries) | |||
| HOW CAN I SCAN DATA WITH COLUMNS AND ROWS DIRECTLY INTO SPREADSHE. | New Users to Excel | |||
| Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions | |||
Linear Mode
