Excel Column Data

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have imported data from a Text file into excel. There
are 3500 rows of data in the single column. I want to
take the data and place it in 40 rows across and 40 rows
down then repeat until all the data has been distributed.
 
Steve,

If the data currently in cell A1 goes into cell B1, where to you want the
data from A2? in C1 or in B2?

HTH,
Bernie
MS Excel MVP
 
Back
Top