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??

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??

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??

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??