Multiple columns consolidated

[LJBorders]

I have Tickets that are assigned to up to 6 different teams. I want to change the data to show the Assigned Teams in one column instead of 6. I also need other columns to stay with the tickets. I used several Transforms and then joined them, but the problem is that it's showing all statuses for a ticket for each team. So it will show Team 1 with the team 1 status, but will also show Team 1 with the Team 2 status.

I can't figure out how to keep the together. Newbie, obvs.

There are 2 tabs on my file. One showing the data I'm working with and the second showing how I'd like to see it.

[ChrisTX · Accepted solution]

See attached workflow.  Transpose and Crosstab are a very useful combination.

In your sample input data, column R should be Project Point of Contact 5 (not Project Point of Contact 6)

 

Chris

[LJBorders]

Thank you so much! This is great!