close
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
quot;Wanquot; gt; wrote in message
...
gt;I have a data in e.g. 10 rows and 20 columns. How do I stack the data so
gt;that
gt; I it is one column, such that data in column B is below data in column A,
gt; data in column C below column B and so on. Thank you.
全站熱搜
留言列表
