 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Splitting 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?? Copy and paste would be my first choice.  SignatureJim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Tall Bill" <Tall Bill@discussions.microsoft.com> 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?? > > Copy and paste would be my first choice. 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. SignatureJim 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. > "Tall Bill" > <Tall Bill@discussions.microsoft.com> [quoted text clipped - 10 lines] > A F = fifth table> > Is this possible?? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.