-1

I'm using a query to pull data from a multi-sheets in Google Spreadsheet that is populated by a Google Form. If the form has only numbers, there is no problem. However, if there's a mixed of text and number then it did not work.

=QUERY({Sheet1!A:S;Sheet2!A:S},"SELECT* WHERE Col4<>''",0)

EDIT: Added the second one here:

=QUERY(Sheet2!A:S,"SELECT A,C,D,E,F,G,H,I,J,K,L,R WHERE G IS NOT NULL ORDER BY G LABEL R 'FRUIT'",TRUE)

Regards,

tt3
  • 31
  • 1
  • 9

1 Answers1

0

Yes, this is how QUERY works. It only pulls the most frequent data type per column. To pull mixed data types, you can use FILTER:

=FILTER({Sheet1!A:S;Sheet2!A:S},{Sheet1!D:D;Sheet2!D:D}<>"")

Erik Tyler
  • 9,079
  • 2
  • 7
  • 11
  • That worked but how about this ''=QUERY(Sheet2!A:S,"SELECT A,C,D,E,F,G,H,I,J,K,L,R WHERE G IS NOT NULL ORDER BY G LABEL R 'FRUIT'",TRUE)'' – tt3 Mar 14 '21 at 21:19
  • There are too many unknowns without being able to see your data and types. However, keep in mind that Stack and other forums are designed to share knowledge ("how to") in small units with a lot of people. Forums are not places where people can get free coding or formula-writing services. I encourage you to learn how FILTER works and how virtual arrays work. Beyond that, your best bet for receiving help will be to share a link to your sheet so others can see your data; then you may receive more replies. – Erik Tyler Mar 14 '21 at 22:48
  • Sorry about that. I got only the number in second Query in column H but there's mixed of text and number. Let me try it. Thank for your help – tt3 Mar 15 '21 at 00:49