CODEWITHSUNDEEP
google-sheetspivot-table
mpsbhat
mpsbhat

Reputation: 2773

Reproduce Pivot table with QUERY formula

I have a sample spreadsheet here and there is report in Sheet2 using query =QUERY(Sheet1!A1:D13; "select A, B, C order by A, B, C", 1) and report in Sheet3 using in build Google spreadsheet pivot table.

How to arrive a same format to pivot table in sheet3 as in Sheet2.

Upvotes: 3

Views: 7434

Answers (1)

Jacob Jan
Jacob Jan

Reputation: 1197

Try using the following formula.

Formula

=QUERY(Sheet1!A1:D13; "SELECT A, SUM(C) GROUP BY A PIVOT B")

Screenshot

enter image description here

Note

This will at least group the names.

Upvotes: 5

Related Questions