Hello, everyone! I can't understand the reason for such a strange behavior of the Query function in a table.

1 year ago 5 Replies

Dmytro Bukach 1 year ago

Hello, everyone!
I can't understand the reason for such a strange behavior of the Query function in a table.
Data from cells that are before the date are merged into one.

2 Likes

Replies

Fiktur Fox 1 year ago

That's because you have a mixed data types in your source range/data. Try formatting your source data to plain text.

0 Likes

Fiktur Fox (1 year ago)

Jennisel Bien Brillantes 1 year ago

Try =query(A1:A10, “select *”,0)

0 Likes

Ravi Yadav 1 year ago

=query (a1:a10, "select*",0)

0 Likes

Timothy Welch 1 year ago

https://youtu.be/cEL-2vWoQBY

1 Like

Relate Discussions

• Hello, everyone! I can't understand the reason for such a strange behavior of the Query function in a table. 4 Replies

• I am cleaning up a set of sheets to make it sortable, there are some merge cells in the data, what is the easiest way to find these merged cells so that I can remove any merged Cells? 6 Replies

• Does anyone know how I can list the conventions in another sheet in this document? 11 Replies

• I need to find all instances of values containing "Month's" (yes, ironically the thing I need to find -- is a typo within the report. 5 Replies

• Question about Query language. Who here is great at this? 2 Replies

• I would like to filter the data with range of dates (from-to). 3 Replies

• how do I use conditional formatting to highlight the merged cell and the 2 separate cells under the heading? 5 Replies

• However, it does not seem to pull through all the data when there are no criteria selected for it to filter by. 2 Replies

• Working on this formula to find the cound of same information across all these cells and count and labelm them 3 Replies

• I would like to use an ARRAYFORMULA with a QUERY function wich call external cells and I fail to do it. 5 Replies