GoogleSheets Query formula skipping a cell
I've got a sheet where I'm using a Query formula to create a small "reporting section"
It's working fine except for the fact that it's missing data for the top right cell.
I've put a simplified screenshot below
So the query is basically getting data from the bigger table on the left where Column B matches the name in cell G2.
It's working fine, in that it is returning the data when I change the employee name, but for some reason, it skips the top right cell (highlighted in red)
It should say Figures there, but for some reason it's empty and I can't figure out why.
Even if I take out the where clause in my query formula. I get all the data, and the Figures value is in the top row, but further down it's missing, and I have no idea why.
query()function only supports one data type per column. The subheadings are text, and will be returned as null because they are in a numeric column.
To make it work, put these values in cells B1:D1:
The choose View > Freeze > 1 row and delete the rows in the data table where column C is
Project Name, and modify the formula like this:
=query(B1:D, "where B = '" & G2 & "' ", 1)