How can I pivot like this using power bi

[ENGFAKAYODE]

Hi Everyone,
I'm trying to

get the output below,I've tried pivoting,groupby and summarize but haven't gotten the desired output.

	Input
Project ID	Manager	Coordinator
P1	John	Chris
P2	Chris	Chris
P3	Kam	John

	Output
Name	Project Count	Reference Details
John	2	(P1,P3)
Chris	2	(P1,P2)
Kam	1	(P3)

[ENGFAKAYODE]

Here is a table showing the output needed

[nitinrungta]

Hi
I was not able to make sense of the Reference logic.

Plus, could you show me how you want it to be used in a Visual, or after you have this information, what all you want to do with it in the calculation?
Instead of consolidating it, it would probably be best if you could get it more expansive in terms of row count.

[ENGFAKAYODE]

I'm new to power bi,just trying to solve a challenge

[Shahfaisal · Accepted solution]

You will need to convert the values in rows into comma separated values.

Try this - https://aditya-somwanshi.medium.com/how-to-convert-rows-to-comma-separated-values-in-power-bi-d04a5c...