View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tall Bill Tall Bill is offline
external usenet poster
 
Posts: 1
Default 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??