| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to split data into columns and arrange the resulting data
I have data in cells A2, A3 and A4 as below:
1, 2, 4, 5, 7, 8 1, 2, 3, 4 2, 3, 4 I want to split into columns (which I did using Data Text to Columns option). But I also want the data to "automatically" fall under appropriate heading (1, 2, 3, 4, 5, 6, 7, 8) which are in respecive cells A1:H1. Thank you in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| duplicate data in columns | Excel Discussion (Misc queries) | |||
| Data in table, may need to convert to columns with OFFSET? | Excel Discussion (Misc queries) | |||
| Pivot table - printing specific data | Excel Discussion (Misc queries) | |||
| Newbie questions on spreadsheet | Excel Worksheet Functions | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Threaded Mode
