Concatenate Data using Condition of Search.

Hi m trying to solve this, plz help me out.

I hav set of data in which 2 columns are present Name and Number.
Multiple Names have list of Difference Number which i need to Concatenate with common Separations.
I have attched the sample file with easy example.

Here, try this:

=TEXTJOIN(",", TRUE, IF($A$3:$A$100=E3, $B$3:$B$100, ""))

Put this in E3 to get Names:

=UNIQUE(FILTER(A3:A500, A3:A500<>""))

And then in F3 above formula

Works like a charm.. u guys rock.. thks for quick responses.. cheers

Power Query

Please Login or Register  to view this content.