Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Grouping/Pivot

Hello!    I have a Query table like this: ID Name QA1 QA1_ErrorType1 QA1_ErrorType2 QA1_ErrorType3 Weekly_QA Weekly_QA_ErrorType1 Weekly_QA_ErrorType2 Weekly_QA_ErrorType3 Followup_QA...
  • Anonymous's avatar
    Anonymous
    6 years ago

    You just have to use the Group function in Power Query, grouping by your id and summing other columns. The first icon on the toobar "Transform"