excel data table reformat

  • Thread starter datamanipulator
  • 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?
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top