passing columns to rows

[Syndicate_Admin]

Hello, I have the following problem.
I have a single table which has many records and the situation that arises is the following:

user id area
1 management frameworks
2 pepe management
1 frame system

in this simple example you can see that a user can be assigned to more than one area, what I want to achieve is to leave it as follows:

user id area
1 frameworks administration, system
2 pepe management

Is it possible to do that? Could you please help me?
Thanks a lot.

[Anonymous]

@Syndicate_Admin Look here: https://gorilla.bi/power-query/aggregate-text-values/

[Syndicate_Admin]

Thank you very much for the help.
With the video I am much clearer!!!

Thanks again.

[Greg_Deckler · Accepted solution]

@Syndicate_Admin You should be able to do a Group By in Power Query or you could use DAX SUMMARIZE/SUMMARIZECOLUMNS with a CONCATENATEX

[Syndicate_Admin]

Thanks for answering, could you indicate how it could be done in power query??
Thanks in advance.