| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing column data to row data
Hello I have a large spreadsheet of excel data formatted in colums when I need it in rows. Currently it is e.g., A K 1 A l 2 A m 3 A n 4 B k 1 B l 2 B m 3 B n 4 When we need it to look like e.g.,: k l m n A 1 2 3 4 B 1 2 3 4 I have figured out that I can cut and paste/transpose but please help me keep my hair...is there a faster way? Thanks for your help Maria in New Zealand |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort or filter rows without column A data changing? | Excel Discussion (Misc queries) | |||
| Record changing cell data into a column or range | Excel Worksheet Functions | |||
| Changing entire column data | Excel Discussion (Misc queries) | |||
| How to set up a column to accept changing data from 1 cell on ano. | Excel Worksheet Functions | |||
| Changing the Direction of Data within a Column | Excel Worksheet Functions | |||
Threaded Mode
