Forum Discussion
Help me add one more filter in my let formula
Hello, I need some help with this let formula. The way it works now is that it combines multiple tables in one single table without blank rows. I'm not able to add one more filter to it. I need to ...
You can use this:
=LET( header, Table1[#Headers], stack, VSTACK(Table1,Table2,Table3), cleaned, FILTER(stack, TAKE(stack, , 1) <> ""), cleanedVstack, VSTACK(header, cleaned), FILTER(cleanedVstack, TAKE(cleanedVstack, , 1)="Maria One") )Change "Maria One" with each name on the corresponding sheet.
You can use this:
=LET(
header, Table1[#Headers],
stack, VSTACK(Table1,Table2,Table3),
cleaned, FILTER(stack, TAKE(stack, , 1) <> ""),
cleanedVstack, VSTACK(header, cleaned),
FILTER(cleanedVstack, TAKE(cleanedVstack, , 1)="Maria One")
)
Change "Maria One" with each name on the corresponding sheet.
