Concatenate Data using Condition of Search.

[atthershabbir]

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.

[zbor]

Here, try this:

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

[atthershabbir]

It worked well.. will try on actual file and update the main result.. thks

[zbor]

Put this in E3 to get Names:

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

And then in F3 above formula

[atthershabbir]

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

[Czeslaw]

Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Name"}, {{"Count", each _, type table [Name=nullable text, Number=nullable number]}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each [Count][Number]),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Count"}),
    #"Extracted Values" = Table.TransformColumns(#"Removed Columns", {"Custom", each Text.Combine(List.Transform(_, Text.From), ", "), type text})
in
    #"Extracted Values"