I would like to use a LEN function to merge all data from several spreadsheets into one table in a defined area. The last time I used this function was in a Google Sheet, where it worked wonderfully.
={FILTER('OE 17'!N6:O;LEN('OE 17'!N6:N); FILTER('OE 83'!N6:O;LEN('OE 83'!N6:N)} .....
In the picture you can see the table, which is the same on every spreadsheet. I would like to merge this data into an overall table.
I am grateful for any help.