From this :
Col1 Col2
A A
B C
D D
E F
G G

to this :
Col1 Col2
A A
B
C
D D
E
F
G G

Pretty much sorting thing thru.

Thanks.

TC


--
chuttt
------------------------------------------------------------------------
chuttt's Profile: http://www.excelforum.com/member.php...o&userid=16645
View this thread: http://www.excelforum.com/showthread...hreadid=315164