Search code examples
listgoogle-sheetsfilterwhitespacetrim

Create list with value from different dynamic sheets

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

Solution

  • 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}<>"")