stack columns

W

Wan

I have a data in e.g. 10 rows and 20 columns. How do I stack the data so that
I it is one column, such that data in column B is below data in column A,
data in column C below column B and so on. Thank you.
 
B

Biff

Hi!

Try this:

You have a 10 row by 20 column range.

That range is A1:T10.

Enter this formula in A11 and copy down to A200:

=OFFSET($B$1,MOD(ROWS($A$1:A1)-1,10),INT((ROWS($A$1:A1)-1)/10))

Biff
 
Top