i got this value

KK + Q1 + Q2 + Q3
01 + 1 + 2 + 3
01 + 2 + 3 + 4
02 + 5 + 6 + 7
02 + 7 + 8 + 9

i can do pivot query so the result will be something like this

KK + Q1 + Q2 + Q3
01 + 3 + 5 + 7
02 12 + 14 + 16

but the report need to be used reversal format from the result above (Q1, Q2, Q3 as row where KK as Column)

Q1 + 3 + 12
Q2 + 5 + 14
Q3 + 7 + 16

sorry, don't how to format it here so hope u get the idea

i found a solution via UNION query before using pivot for each Q1, Q2, Q3 but just curious is there any other way

any idea?

thanks,