QUERY function not including text cells along with number cells in result

Question

I'm currently trying to copy a list using the QUERY function in google-sheets.

The problem im now facing is that words / letters are not included in the search.

Example picture

Im using the function: "=QUERY(E2:F5;)" but don't get the words included.

Is there any way to include these words by using the formula above as guide?

Answer 1

In google-sheets, use Format, Number, Plain Text on your source range of E2:F5 and your original formula will work.

=QUERY(E2:F5)

From Docs Editor Help - QUERY function

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.