Group mulitple rows into one

[symun123]

I am wanting to group data from one column into distinct rows from another column, is this possible? I have tried the 'Group By' function but it doesn't seem to do what I want.

Here is a screenshot, you can see 'Issue' has multiple rows because the License column has seperated. What I want is one row for issue PCR-466 with all license grouped together in the same row. Is this possible?

[Ahmedx · Accepted solution]

pls try this code in Power query

[symun123]

Thanks, got that working.
Next question if you could help again, instead of listing the licenses as a comma seperated list, is there a way to replace them with the word 'Global'? Tried Text.Replace but that didnt work

[Ahmedx]

show the result you want, otherwise it’s not clear what you want

[Uzi2019]

Hi @symun123 

just simply in your code use "Global" instead of ",".

I hope I answered your question!

[symun123]

This doesn't work as that just replaces the ',' with the word 'Global'. So I still have the list but with the word Global in between each license

[Uzi2019]

can you share the output your getting and expected result result you want??