Filter non-blank rows in columns from multiple tables

[bujubenji]

Hi all,

Apologies if this has a rudimentary answer but I've been scouring online and can't find a solution.

I am building a master workbook which will receive performance figures from 10 teams' individual workbooks.

On the master workbook, I have a sheet for each week to automatically update based the teams individual workbooks for the corresponding week. I was intending to create a table for each team and create a link to the corresponding week for each team (though happy to take direction if there is a better method).

I want to then filter the first column in all ten tables, filtering out the blank rows and compiling the positive entries in an unbroken list elsewhere on the sheet.

I have tried =FILTER with the column name followed by <>"" and an asterisk before opening brackets for the next range and repeating but receive a #VALUE error.

I have tried a filter with nested filter and array constants but receive the same error.

I've tried converting the tables to a range and no luck there either.

Any idea of an alternative method please?

Thank you,

Buju

 

[jaeiow]

Try this

=LAMBDA(rng,FILTER(rng,BYROW(rng,LAMBDA(r,AND(r<>"")))))