Help with pivoting

[Mark_Earll]

I am trying to pivot the following table. Any suggestions?

[MartinDDDD]

Use Pivot Node:

• Column Name => Group Column
• Column Variable Heading => Pivot Column in Pivot tab
• Column Value ==> Manual Aggregatio tab - select sum, mean or whatever is the aggregation method you have used in your example.

Update: Ok I see - you want the first item to appear. There should be an aggregation method “First”.

[Mark_Earll]

Thanks - My problem was I did not put anything into the Manual Aggregation tab - doh! Works fine - Many thanks!

[MartinDDDD]

Happens to the best :-).

If this solved it I’d appreciate for you to flag it as Solution - helps the next one searching for similar issues get to the solution a little quicker