Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Grouping Query - Merge Rows

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

 

  • Hi, Anonymous select Year column and unpivot other columns. Then pivot column with former column names.

1 Reply

  • Hi, Anonymous select Year column and unpivot other columns. Then pivot column with former column names.