sort data
 

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

sort data
 

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