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 ki...
  • AlienSx's avatar
    2 years ago

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