| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I move data from a row range to a column range
I have random data in rows eg. A1 to A20. I want to move all data to columns
A-T as follows: data from A2 to cell B, data from A3 to cell C, data from A4 to cell D, etc. Or vice versa from columns to rows. What is the quickest way of acheiving this other than the laborous cut and paste of each cell individually? Many thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AVERAGE a range in a column if another column's range equals a val | Excel Discussion (Misc queries) | |||
| Range Names That Move With Cell Data | Excel Worksheet Functions | |||
| formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| HELP REF. NEW DATA ONLY AS i MOVE TO ANY CELL IN THE NEW ROW/RANGE | Charts and Charting in Excel | |||
Threaded Mode
