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.
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.