Turning a row into a new kind of column

[TormentMaker]

Hey guys, hope everyone's doing well, so i got a problem with Alteryx Designer where i want to change the way i view the data of my table, gonna show a example to make it easier to understand:

I have this:

Name	Date	Free Hours
Lucy Stevens	21/05/2021	0
Lucy Stevens	22/05/2021	9
Pietro	21/05/2021	9
Pietro	22/05/2021	9
Manoel	21/05/2021	9
Manoel	22/05/2021	0

And i want this table above to turn into this:

Name	21/05/2021	22/05/2021
Lucy Stevens	0	9
Pietro	9	9
Manoel	9	0

[atcodedog05 · Accepted solution]

Hi @TormentMaker 

This can be easily done by crosstab tool and dynamic rename

1. Cross tab tool key as Name, name as Date and value as free hours.

2. Dynamic rename tool to replace "_" to "/"

Hope this helps🙂

[TormentMaker]

Yeah thats exactly what i needed, didnt even had to use the Dynamic Rename with my project tho

Thanks buddy