I have a list of different values that are dynamic in column A, I have to put them together into a main sheet big list.

Now I have a list with empty spaces for the income values but this is not saving me a lot of time, I would like to have something as the image red square, something like this:

Help please!

CodePudding user response：

There are different ways to do that.

=QUERY(C:C,"select * where C is not null")

You can use FILTER() function like

=FILTER(C:C,C:C<>"")

CodePudding user response：

Try this

=query({Sheet1!A1:A;Sheet2!A2:A;Sheet3!A1:A},"where Col1 is not null")

or

=query({Sheet1!A1:A;Sheet2!A2:A;Sheet3!A1:A};"where Col1 is not null")

according to your locale