transpose

[Kjaer]

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

[AngelosPachis · Accepted 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

[Kjaer]

Hi

Thanks a lot. Now it works.

Best regards

Thomas

[ll98]

Hi 

I have same issue with transpose -- where I'm not getting the results that I'm looking for .. I attached the WF with the input as well as how I want the data to represent in excel.  Any help is greatly appreciated,.