Google Sheets – Google Spreadsheet Query Blanks Out Text Cells in the Query Range

google sheetsgoogle-sheets-query

When I perform a query to essentially filter a range of names, and times, any cell that is not a time gets blanked out. Screenshot of example:

enter image description here

I'm keeping this post fairly short since the image succinctly describes the problem. Whats causing this, and how do I correct it?

Best Answer

QUERY result assigns a data type to each column. The "blanked out cells" occurs because their data type is not compatible with the data type of the resulting column.

Instead of QUERY use FILTER.

To learn more about QUERY see https://support.google.com/docs/answer/3093343?hl=en and https://developers.google.com/chart/interactive/docs/querylanguage.

Related Topic