Make tables the same length in different sheets

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I feel that you could modify your formulas and produce a pseudo table.
The formula in column B could be modified to read: =IF(SUMPRODUCT(--(C2:G2=""))=5,"",COUNTIF($C$2:C2,">"""))
The formula for columns C:G could be modified to read: =IF(AND(INDEX(Tasks!C:C,ROW())>0,INDEX(Tasks!D:D,ROW())=""),INDEX(Tasks!$B:$B,ROW()),"")
Note that in the attached file the formulas are filled through row 29.
If you would like the banded rows, conditional formatting could be set using: =AND($B2<>"",ISEVEN(ROW()))
Let us know if you have any questions.

You're Welcome and thank you for the feedback. If this resolves the issue please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.