I receive answers via a Google Forms, which I want to put in a pivot QUERY. I made a query that does the job for all rows, but in the case of duplicate answers, I only want to include rows with the same values in column A, B, and C once.
Here is a sample spreadsheet with the data in the
Data sheet, my query in the
What I have sheet:
=QUERY(Data!A1:E, "SELECT C, SUM(D) WHERE A IS NOT NULL GROUP BY C PIVOT A",-1)
and what I am asking for in the
What I need sheet.