Creating pivot in column level in Alteryx

[Celeya]

Hi. Iam working on a project were one of the reports look like this. (Excel Pivot snip) This has Client Name, project name and Project ID in row level and Sum of week 06/08/2024 and Sum of Week 06/15/2025 in values field where Resources is added in the Column level. I need to replicate the same look in Alteryx. I tried the Transpose and cross tab to get this look, (Alteryx snip) but i expect a view similar to excel pivot.

[Qiu · Accepted solution]

@Celeya 
There is a Pivot feature in Table tool. Maybe you can check if it suits your requirement.

[Celeya]

@qiu Thanks for sharing this .. It works

[Qiu]

Happy to be any help.