list numbers in a block of cells

  • Thread starter Thread starter Jeff Klein
  • Start date Start date
J

Jeff Klein

Is there a way to list the values in a block of cells.

400 600 800
350 200 625
250 222 125
9958 226 123


Like:

400
600
800
350
200
625
250
222
125
9958
226
123
 
Assume source data in A1:C4

Put in say, E1:
=OFFSET($A$1,INT((ROWS($1:1)-1)/3),MOD(ROWS($1:1)-1,3))
Copy E1 down to E12
 
Back
Top