stack columns
 

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.

stack columns
 

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

"Wan" wrote in message
...
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.