Quick help on Simple Excel formula

[Monty]

Hello Experts..
Iam struck with a simple formula for you guys..please help.

format

Col A Col B
1 A
1 B
1 D
2 C
2 K
2 N

Now what iam looking from above data is;


OUTPUT

1 A,B,D
2 C,K,N

Plese help...i don't have excel on my system to upload excel file..Hope this helps..

 

[Hui]

Have a read of this post: http://chandoo.org/wp/2008/05/28/how-to-add-a-range-of-cells-in-excel-concat/
Then look for some of the Concatif() functions I describe in the comments of the post

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[bosco_yip]

Another option,

1] Helper C1, formula copy down :

=IF(A1=A2,B1&","&C2,B1)

2] Output H1, formula copy down :

=IFERROR(INDEX(A$1:A$17,MATCH(,INDEX(1-ISNA(MATCH(A$1:A$17,H$1:H1,)),),)),"")

3] Output I1, formula copy down :

=IF(H2="","",VLOOKUP(H2,A$1:C$17,3,0))

Regards
Bosco