Cross Tab multiple fields

[HannahSwain7]

Hi,

I am trying to use the cross tab field to create multiple columns. Below is my current data set. How do I change this so the fields are in the following format please 2022 program type, 2022 program cycle, 2022 fit in role, 2023 program type, 2023 program cycle etc. Thank you in advance!

[alexnajm]

Transpose the headers down, add the columns together using a Formula tool, so then you have one column you can Crosstab on!

ToString([Program Year])+"_"+[Name] should do it. If you want more direct help, please post the data instead of a screenshot!

[HannahSwain7]

Sorry not sure I follow! Please see below the data. Thank you!!

[alexnajm]

Here it is based on how I understand it above: