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

enter image description here

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.

enter image description here

1 answer

  • answered 2021-05-03 18:12 doubleunary

    The 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:

    Employee Project Name Figures

    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)