| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Data from a number of rows and columns to one column
How can I get my data after doing a paste special transpose from looking like
this: A B C D 1 1 1 1 2 2 2 2 3 3 3 3 To look like this: A 1 2 3 B 1 2 3 C 1 2 3 D 1 2 3 Any help would be much appreciated. Thanks, Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Last Number in a column | Excel Discussion (Misc queries) | |||
| Number of Column Limitations | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
| Making Rows into Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
