Creating a SELECT and GROUP query in Google Sheets results in a duplicate ‘group’ column (Col Q) at the end of my Gviz URL. I want to edit the query so that this duplicate column (4th column) does not appear in my Gviz URL output. This is my query:

select Q, Y, J, max(Q) where Y is not null and not Y like ‘[%’ group by Q, Y, J

How do I drop columns at the receiving end? (I do not want to change the columns in the sheet itself).