Power Platform Community Forum Thread Details

Hi Everyone,

I have spent the day on this and should have come here much sooner. I am trying to do what seems like a simple task and I can't work it out.

I have a very simple list, it has Project Managers and their associated Project Numbers. There are other elements but I have filtered these.

I have created an array and have removed duplicates.

What I am trying to do now, is simply take where I have one Project Manager who appears against multiple projects, transpose this so the resulting table will show their name and all the corresponding projects alongside. Thus reducing total rows in my table and looking smarter.

My Data comes from a sharepoint list. I then use a filter and then select to create the array with only the relevant items.

I considered using union on each to remove duplicates but then you lose the link between the two items and have to create further code to look back and match up to the original. Surely there's a better way I am missing?

Example - Original

PM PN

David 12345

David 67890

Mike 1113

Stacey 1092

Stacey 8775

Zach 18228

Desired Result

PM PN(s)

David 12345, 67890

Mike 1113