Grouping/Pivot

Question

Hello!&nbsp;&nbsp;I have a Query table like this:IDNameQA1QA1_ErrorType1QA1_ErrorType2QA1_ErrorType3Weekly_QAWeekly_QA_ErrorType1Weekly_QA_ErrorType2Weekly_QA_ErrorType3Followup_QAFollowup_QA_ErrorType1Followup_QA_ErrorType2Followup_QA_ErrorType31234Peter1100000000001234Peter0000100000001234Peter000000001001It is just an example, there are many names, IDs and 0/1 combinations in my table.I need to write a table which would have information on all QAs for each unique IDs:IDNameQA1QA1_ErrorType1QA1_ErrorType2QA1_ErrorType3Weekly_QAWeekly_QA_ErrorType1Weekly_QA_ErrorType2Weekly_QA_ErrorType3Followup_QAFollowup_QA_ErrorType1Followup_QA_ErrorType2Followup_QA_ErrorType31234Peter110010001000.....&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Please let me know how to do it in Query Editor?

anonymous · Accepted Answer

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"

Forum Discussion

Grouping/Pivot

1 Reply

Related content

Pivot or Group

Pivot columns vs group

Pivoting/Grouping Dates

Pivot / Transpose rows by group

Group columns on pivot table

ID	Name	QA1	QA1_ErrorType1	QA1_ErrorType2	QA1_ErrorType3	Weekly_QA	Weekly_QA_ErrorType1	Weekly_QA_ErrorType2	Weekly_QA_ErrorType3	Followup_QA	Followup_QA_ErrorType1	Followup_QA_ErrorType2	Followup_QA_ErrorType3
1234	Peter	1	1	0	0	0	0	0	0	0	0	0	0
1234	Peter	0	0	0	0	1	0	0	0	0	0	0	0
1234	Peter	0	0	0	0	0	0	0	0	1	0	0	1