Dynamic crosstab

[davidogundipe]

I'm trying to figure out how to make a dynamic crosstab that will make new column names (ex: manager 1, manager 2, manager 3, etc). I've attached a sample excel document that shows how it looks now vs how I would like it to look. I've tried, but I can't figure out a solution. Please help if you can! Thanks!

[ChrisTX]

Do these related posts help?

Calculating with rows of data dynamically (number of rows is same, number of columns changes)

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Calculating-with-rows-of-data-dynamica...

Dynamic crosstab?

https://community.alteryx.com/t5/Alteryx-Designer/Dynamic-crosstab/td-p/600351

Chris

[Qiu · Accepted solution]

@davidogundipe 

This should help.

[davidogundipe]

Thanks!