Create list with value from different dynamic sheets

user_16239103 0
Viewed 70

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

In the image the color squares are the different sheets and in the right is the merge sheet where I need this merged list with the values from all the other sheets something like this:

enter image description here

google-sheets trim filter whitespace list
3 Answers

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<>"")
user_55147470

use:

=FILTER({'Sheet 5'!A:A; 'Sheet 6'!A:A; 'Sheet 7'!A:A}; 
        {'Sheet 5'!A:A; 'Sheet 6'!A:A; 'Sheet 7'!A:A}<>"")
user_56326290

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

user_150193800
Related