VSTACK and FILTER functions

[AuDHDtism]

Hi there,
I need a formula to combine table 1 (Daily Chores) data (B5:D29) with table 2 (Weekly Chores) data underneath with the data going into table 3 (Summary of chores). The tables each have 3 columns (Area, Chore, Time). However, I end up with many blank rows as the tables are not full with data. this is because I want to be able to add chores to the daily and weekly tables as needed.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=LET(v,VSTACK(Table1,Table2),FILTER(v,TAKE(v,,1)<>""))

Although this will only work in a normal range & not a table.

 

[AuDHDtism]

Thank you for sharing. Unfortunatly the XL2BB isn't working and I'm not as tech savvy as I'd like.

 

[AuDHDtism]

Just wanted to say thank you again as it worked and I am so appreciative.

 

[Fluff]

You're welcome & thanks for the feedback.