Transposing rows to columns

This would be simple to do in Excel, but I can't figure it out on FME. The problem is I need to transpose or pivot rows to colums, as in example (I have formatted and calculated the totals to first box):

I have tried with AttributePivoter and AttributeCreator/Aggregator, but it doesn't work. Any help would be appreciated, I've tried to google, but with no luck. I have also tried to pivot the unprocessed data and calculate it there.