How to use Column Value as header in Query in google sheet

Viewed 38
1 Answers

Something like this should work, needs tweaking with ordering though.

=query(Sheet1!A1:C71,"select B, sum(C) group by B pivot A")
Related