Expanding Cell Results into a list

[RobMueller]

Good Day

I have a column where the data has been collected showing several results on the same line rather than a seperate line per result. Is there a way in PowerBi to automatically change this.

I need PowerBi to see this in a row

John Smith          An Example        3531663, 3532139, 3532394, 3532566, 3533469

And to change it to

John Smith          An Example        3531663

John Smith          An Example        3532139

John Smith          An Example        3532394

John Smith          An Example        3532566

John Smith          An Example        3533469

[DOLEARY85]

Hi,

the easiest way to do this is in Power Query. If you group by name, and whatever column an example is and use Max to aggregate on column 3. In advanced editor change the Max section of the code to Text.Combine it'll give you what you need. I've included the code below with the section changed in bold.

Also make sure the column you're combining is a text field.

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8srPyFMIzs0syVDSUXLMU3CtSMwtyEkFcoxNjQ3NzIyVYnUIqTIxNiKgytDI2MTUzFwpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t]),
#"Grouped Rows" = Table.Group(Source, {"Column1", "Column2"}, {{"Column 3", each Text.Combine([Column3], ", "), type text}})
in
#"Grouped Rows"

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[RobMueller · Accepted solution]

Thank you for the help. Trying to follow your steps I managed to find the answer.

In Power Query, as you mentioned the column first needs to be text.

Then it was just a case of right clicking the column header and selecting "Split Column" and "By Delimiter" then in the advanced options ensuring it was rows not columns.