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.

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" <Wan@discussions.microsoft.com> wrote in message
news:C3C2793B-CC29-40BA-93B8-7CF202E230BA@microsoft.com...
>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.