Transpose Excel Columns & Rows / AttributePivoter

Hi ​@galigis, recently I answered a comparable question, check out this link. I think it is what you are looking for :)

Rows to Columns | Community

Thanks ​@lambertus - I have tried the hub transformer but unfortunately didn’t work for me ,

Alternatively, I was able to achieve the requested pivot table by adding the following transformers:

• StatisticsCalculator
• AttributeCreator
• AttributeExposer
• AttributeKeeper
• Aggregator

Attached the template for reference, below an example of the final output:

I hope this is helpful to anyone who needs it

Thanks :)

Hi ​@galigis, happy to hear that you created a nice solution yourself! 😃

I am still interested what went wrong for my own workspace, maybe a difference in FME version plays a role..