| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Arrange data spanning 8 columns and 3 rows to 24 columns and 1 row
I know the transpose option under Paste Special menu will arrange data from
horizontal to vertical and vice versa. Is there a function or formula that will re-arrange data from multiple columns/rows into one row? For example, from 8 columns across and 3 rows down to 24 columns across and 1 row down? (I have 1000 rows of data, so manually would be a time-consuming process). Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| how do i arrange columns by its numerical position with a click | Excel Discussion (Misc queries) | |||
| how to split data into columns and arrange the resulting data | Excel Discussion (Misc queries) | |||
| arrange columns alphabetically in Excel | New Users to Excel | |||
Threaded Mode
