| 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?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Splitting a multi-column table in single columns
Copy and paste would be my first choice. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Tall Bill" <Tall wrote in message 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?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Splitting a multi-column table in single columns
Thanks for the suggestion. I realize that copy and paste is "the" option but
was just wondering - is there anything magical out there?? "Jim Cone" wrote: Copy and paste would be my first choice. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Tall Bill" <Tall wrote in message 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?? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Splitting a multi-column table in single columns
The only magical thing I can think of is to use the Ctrl + Shift keys.
You can select then drag a column (while pressing those keys) and the column will be copied and inserted when you let up on the mouse button. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Tall Bill" wrote in message Thanks for the suggestion. I realize that copy and paste is "the" option but was just wondering - is there anything magical out there?? "Jim Cone" wrote: Copy and paste would be my first choice. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Tall Bill" <Tall wrote in message 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?? |
| Reply |
| 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 | |||
Linear Mode
