I'm new to query and can't figure out how to get grouped results of sum in two columns.
There's data set in the picture of names and points which are in two columns and query formula to sum and group the results for first two columns.
=QUERY(AF2:AJ34; "select AG, sum(AH)
where AG is not null
group by AG
order by sum(AH) desc
label AG 'Name', sum(AH) 'Points'")
How can I get the same result but from both columns of points?