The screenshot below is the data that I want to export to another google sheet:
The screenshot below is my destination google sheet with data imported from the google sheet above:
May I know why ALL is missing in Cell CD14 when I import the data using IMPORTRANGE & QUERY? How should I fix it so that everything will be imported? Thank you.
Query has issues with mixed data types. See also here
To work around that you can either format column CD as text (in the source table) or convert everything to text after it is imported.
=Arrayformula(iferror(query(importrange(...., ...)&"", "Where Col5 = 'Transmit'")))
&"" behind IMPORTRANGE?
CJ is actually a time.You should be able to keep all original data types by using FILTER rather than QUERY, e.g.:
=IFERROR(FILTER(IMPORTRANGE(NameList!C3,"Sheet9!C14:J18"),IMPORTRANGE(NameList!C3,"Sheet9!G14:G18")="Transmit"))
I will add that, if you plan to be importing more than this one formula's worth of data using IMPORTRANGE, it will be more efficient to use IMPORTRANGE to import into its own sheet in your destination spreadsheet the entire range you'll ever want to reference from it, and then write your processing formulas referencing that new sheet rather than by making individual IMPORTRANGE calls (which will slow down your sheet). If you do use the one IMPORTRANGE call to get all the data you'll need into the destination sheet, you can just hide it and leave it in the background if you like.
C14:J18. That's why I'm using QUERY function as it allows me to do something like Query({IMPORTRANGE(NameList!C3, "Sheet9!C14:J18"), IMPORTRANGE(NameList!C4, "Sheet9!C14:J18"),...}, "WHERE Col5 = 'Transmit'")