Hi
I have attached table 1 as I want to transpose to table 2. I can´t find the solution. Can you help me?
Best regard
Thomas Kjaer
Solved! Go to Solution.
Hi @Kjaer ,
The first step would be to transpose your year columns because you want those in rows in your output. But because you want to have your Afd fields as column headers later on, you should group on those during transposing to keep them in a single column.
After you transpose your data, you should have your new column headers in one column (Afd), the new values in another column and finally the field to group by (your year) in a third separate field. Now you should use the cross-tab tool, to bring the data back to the desired format.
Hope that helps,
Angelos
Hi
Thanks a lot. Now it works.
Best regards
Thomas