sort data

  • Thread starter Thread starter kokhong
  • Start date Start date
K

kokhong

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
 
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/3000-2077_4-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
 
Back
Top