excel data table reformat

  • Thread starter Thread starter datamanipulator
  • Start date Start date
D

datamanipulator

I have an excel table of 13cols and n number of rows that I need to reformat
into two columns and m rows- moving the cols by rows into the second tableie
A1, b1, c1....A2, b2, c2..... into A1,b1, c1, A2, b2, c2..... any quick
epressions outhere?
 
This is a bit confusing. Did you mean 3 columns or 13 (as you wrote)? And
how is the second table to be arranged? Like this:

A1 B1
C1 A2
B2 C2
A3 B3
C3

Please advise further.

Pete
 
Back
Top