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