Howdy! I have some Task Order and Sub Task Order data which is like contract data. I am trying to show the Sub Task Supervisor for each Sub Task. The problem is that in the original data there is more than one ID in the field, sometimes. I can pivot the data to show just one ID which is fine but it reduces the level of detail for my view and I working with financial data in my real data which is exploding my values after joining.
What I would like is to join the data re-pivot the data to show the names like this: Harry|Suzie|Joe. This is fine as I would only show this value via a tool tip.
I have included some raw data:
- Task Order Sub Task Order Data is the basic table.
- Sub Task Order Supervisor contains the names. It joins to the Task Order Sub Task Order Data via the Sub Task Supervisor List
- Final View I am looking for is an example of what I am looking for.
What I am getting right is something that looks like One Hot Encoding and that's not the result that I am looking for.
Thanks,
Scott

Hello @Scott Carman ,
See the attached flow. The trick is to aggregate the rows back up after you pivot and join.
@Robert Breen