Excel_ changing M x M data to single column

  • Thread starter Thread starter Jane
  • Start date Start date
J

Jane

Hi there, anybody know how to get data from a 40 colum x
50 row worksheet into a single column, without timely
cpoying and pasting???

Thanks
 
Hi
if this data is on sheet 1 (starting in A1) enter the following on
sheet 2 in cell A1
=OFFSET('sheet1'!$A$1,INT((ROW()-1)/40),MOD(ROW()-1,40))
and copy down
After this select column A, copy it and goto 'Edit - Paste Special' and
insert the data as 'Values' to clear the formulas
 
Back
Top