Moving columns into one row

**oliver79** · 06-23-2010, 05:36 AM

Hi all,

Just wondering if someone can help me with the following.

I want to move data in colums into one column with many rows, so if I have the following:

A B C D E F G
1 2 3 4 5 6 7
8 9 10 11 12 13 14

I want to move all of this into:

A
1
2
3
4
5
6
7
8
9
10

Can someone please help me in doing this.

**Cheeky Charlie** · 06-23-2010, 07:43 AM

If your source data are 7 columnes wide:

=INDEX($A$1:$G$10,ROW(7:7)/7,1+MOD(ROW(7:7),7))

where:
$A$1:$G$10 is the table to be manipulated
and all the 7s are replaced with the actual number of columns as apt.

hth

**oliver79** · 06-23-2010, 09:41 AM

Hi,

Struggling getting that to work.

I have attached the spreadhseet I'm working on....would you be kind enough to show me how this works on it please.