convert table to list

[herwig123]

Hi there,

I got the following table:

A B C D
11 22 33 44
12 23 34 45
13 24 35
14 25 36
15 37
16 38
17 39

which I would like to convert to the following:

A 11
A 12
A 13
A 14
A 15
A 16
A 17
B 22
B 23
B 24
B 25
C 33
C 34
C 35
C 36
C 37
C 38
C 39
D 44
D 45

Any hints how to do that best would be highly apprechiated?


cheers,

Herwig

Ps: just saw that it does not display the top table properly (all 30ies should be under each other in colum C) - working on editing it.

 

[Kaps_mr2]

http://www.automateexcel.com/2008/10/21/convert-matrix-to-vector/

should do it. Thanks

Kaps

 

[herwig123]

Hi Kaps,

Thanks for your quick answer.
Somehow I don't seem to be able to implement it.
It also doesn't seem to write the header of each row next to the vector.
Any ideas?

cheers