Turning 2 row table into a multi-column table

**kle** · 05-24-2013, 08:33 PM

Is it possibleto convert a 2-row table such as the one below:

Name 1 Name 2 Name 3 Name 4 Name 5 Name 6 Name 7 Name 8 Name 9 Name 10 Name 11 Name 12 Name 13
Group A Group B Group A Group A Group C Group D Group D Group D Group B Group C Group C Group C Group C

to something that would look like this:

Group A Group B Group C Group D
Name 1 Name 2 Name 5 Name 6
Name 3 Name 9 Name 10 Name 7
Name 4 Name 11 Name 8
Name 12
Name 13

Thanks.

**Ron Coderre** · 05-24-2013, 09:41 PM

Try this...
With your sample data in A1:M2

A5: Group A
B5: Group B
C5: Group C
D5: Group D

• Enter this ARRAY FORMULA, completed by Holding Down CTRL and SHIFT when you press ENTER (instead of just pressing ENTER)
A6: =IFERROR(INDEX($A$1:$M$1,SMALL(IF($A$2:$M$2=A$5,COLUMN($A$2:$M$2)),ROWS($6:6))),"")

Copy A6 and paste into A7:A15
Copy A6:A15 and paste into
...B7:B15
...C7:C15
...D7:D15

You should see the results you want.

Is that something you can work with?