Merging Data in specific area

Occasional Visitor

Screenshot 2022-04-08 172243.pnghey all,


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.

0 Replies