Hello everyone, as a greenhorn, I have probably a stupid question, but I will be really grateful for the answer.
I have source table with data in the format:
YEAR SUBJECT DATA_A DATA_B DATA_C
2017 Joe xyz1 abc1 dlc1
2018 Joe xyz2 abc2 dlc2
2019 Joe xyz3 abc3 dlc3
And I would like report for Joe, looking like:
2017 2018 2019
DATA_A xyz1 xyz2 xyz3
DATA_B abc1 abc2 abc3
DATA_C dlc1 dlc2 dlc3
Is it possible in a easy way? Report shows only values from first (alt. last) row from source table. My only idea is separating source table into multiple tables (for each year) and merge into one table with column for each year (2017_DATA_A; 2018_DATA_A), which doesn't sound very elegant nor clever.
Thank you for anwers and sorry for my english.