| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting a multi-column table in single columns
I have a worksheet containing a table consisting of a stub (1st column) and 5
columns contain figures. I would like to create 5 separate tables with the stub being constant for each table such as: A B C D E F = original A B = first table A C = second table A D = third table A E = fourth table A F = fifth table Is this possible?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting Column in to 2 columns | Excel Discussion (Misc queries) | |||
| Splitting one column into multiple columns | Excel Worksheet Functions | |||
| Splitting single column data into two | Excel Worksheet Functions | |||
| Creating single lines of data from a multi-column table | Excel Discussion (Misc queries) | |||
| Splitting text in one column into two (or more) columns. | Excel Worksheet Functions | |||
Threaded Mode
