Splitting a multi-column table in single columns

  • Thread starter Thread starter Tall Bill
  • Start date Start date
T

Tall Bill

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??
 
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 (e-mail address removed)>
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??
 
Thanks for the suggestion. I realize that copy and paste is "the" option but
was just wondering - is there anything magical out there??
 
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??
 
Back
Top