Grouping/Pivot

[Anonymous]

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	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

It 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:

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	1	0	0	0	1	0	0	0
.....

Please let me know how to do it in Query Editor?

[Anonymous · Accepted solution]

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"