Display all values in columns (Query formule)-CodePudding

I'm trying to use a query function in my google sheet. But I have a little problem :

When I have same/less "R" than date so it display me only date and not the "R"

For example:

Another example:

And now, when I have more "R" so it's display everything:

So how can I display everything when I have same or less "R" (it can b R or any letter) ?

https://docs.google.com/spreadsheets/d/1svXFqHVtbgMfHPZjxS3X9AKW679AqrVyMDySay2lzfw/edit?usp=sharing

Thanks for your help

CodePudding user response：

Try

=QUERY(arrayformula(to_text(H1:J6)),"WHERE Col3 IS NOT NULL " ,0)

the problem comes from a combination of string and numeric value in the same column (date is numeric), query does not work well and you have to convert data into strings. Because the source is now a function, you will have to use Colx instead of letter of column.