Grouping Query - Merge Rows

[Steevo746]

Hi All

I want to consolidate two rows for each year into one - so that it shows values for both Spoiled and Good in a single row rather than two rows for each year with nulls. I have tried all kinds of group by and aggregations but to no avail? any idea?

Thanks!

Steve

[AlienSx · Accepted solution]

Hi, @Steevo746 select Year column and unpivot other columns. Then pivot column with former column names.