splitting a column according to

[D Williams]

Hello,

I have a long list which I wish to split into separate columns according to
an identifer in the first column:

a 12
a 23
a 54
a 56
c 67
c 453
c 434
c 8734
r 3434
r 34
r 66

goes to

12 67 3434
23 453 34
54 434 66
56 8734

Preferably pasting the values into a predefined table on the same sheet. The
length of the column will change, as will the identifier. Does anyone have
any ideas other than cut and pasting?

Thank you ever so much,


Damian

 

[Kieran]

Damian,

Ahve you tried using the text to columns feature on the data menu.
If you specify the data a delimited and the delimiter to a ' ' (yo
knwo a space) then the tool should be the answer

 

[D Williams]

Damian,

Ahve you tried using the text to columns feature on the data menu.
If you specify the data a delimited and the delimiter to a ' ' (you
knwo a space) then the tool should be the answer.

Thanks Kieran,

I have tried using the text to columns but it doesnt work quite as I
would like:

a 12
a 23
a 54
a 56
c 67
c 453
c 434
c 8734
r 3434
r 34
r 66

goes to

12
23
54
56
67
453
434
8734
3434
34
66


The position of the first number in the row is important so the columns
need to be aligned:


12 67 3434
23 453 34
54 434 66
56 8734

Is it possible to 'skip' the rows which are not required in particular
column (therefore aligning the columns as necessary)?

Thanks,

Damian