Forum Discussion
Anonymous
2 years agoNot applicable
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
- AlienSxSuper User
Hi, Anonymous select Year column and unpivot other columns. Then pivot column with former column names.