Hi,

How do I extract all the numbers but not duplicate letters
Eg I have a list in Excel using 2 columns. Column A and Column
respectively

_A___________B_
A 1
A 2
A 3
B 1
B 2
B 3
C 1
C 2
C 3

I would like to transpose it in the following using 4 Columns

Eg

_A__B__C__D_
A 1 2 3
B 1 2 2
C 1 2 3

My guess is that I have to use Arrays with for.. next loops but I a
not sure how do I do that?
Any help is very much appreciated. Thank

--
Anne Mari
-----------------------------------------------------------------------
Anne Marie's Profile: http://www.officehelp.in/member.php?userid=486
View this thread: http://www.officehelp.in/showthread.php?t=124487

Posted from - http://www.officehelp.i