Google Sheets query doesn't display all values

Google sheets query accepts only one data type per column, it detects automatically:

• if Col contains more taxt values: returns text
• if Col contains more numbers: returns numbers.

I solved the same problem with two workarounds:

• use filter or combine filter with query
• make extra column and convert all values into text by adiing any char, and then get rid of it.

---

https://support.google.com/docs/answer/3093343?hl=en

In case of mixed data types in a single column, the majority data type determines the data type of the column for query purposes. Minority data types are considered null values.

In addition to Max' contribution, you can also preprocess the data so that it's all converted to text and THEN wrap the query around this output. Something like

=QUERY(ArrayFormula(TO_TEXT('Contact Changes'!B1:T)),"SELECT Col3, Col4,    Col5, Col6, Col7, Col8, Col9, Col10, Col11, Col12, Col13, Col14, Col17, Col18 WHERE Col19='RMT'")

I had the same problem in the past and today I tried to just format the entire column to "plain text" and it worked perfectly.

No problems anymore and every value is displayed.