Although it can easily be accomplished with VBA Macro - I would suggest
another approach:
1) In the picture - the long formula is an array formula, and is to be
confirmed with CTRL+SHIFT+ENTER rather than with simply ENTER.
The curly brackets {} are not to be typed manually, those are entered by the
Excel, when the formula is entered as an Array formula.
2) Column "C" and on maybe hidden but not deleted !
http://download.cnet.com/Morefunc/30...-10423159.html
3) In order to use the MCONCAT function you will have to install the
MOREFUNC add-in:
http://img13.imageshack.us/img13/6234/nonamek.png
Micky
"kokhong" wrote:
is there any way to sort my data in excel from
IP address Username
10.10.10.1 A
10.10.10.1 B
10.10.10.1 C
10.10.9.2 D
10.10.9.3 E
10.10.9.3 F
TO
IP address Username
10.10.10.1 A,B,C
10.10.9.2 D
10.10.9.3 E,F