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!
¡Resuelto! Ir a solución.
Do these related posts help?
Calculating with rows of data dynamically (number of rows is same, number of columns changes)
Dynamic crosstab?
https://community.alteryx.com/t5/Alteryx-Designer/Dynamic-crosstab/td-p/600351
Chris
Thanks!