Formulas and Merged Cells

Thank you for your welcoming. Not really helpful. Sorry but as i have stated i need to keep the merged cells. I have attached the document for an example

Really appreciate your help!! Thank you

HI kvsrinivasamurthy

Would you be able to help me again?

From the formula you created above is there a way that it can ignore certain text. on Sheet 1 column J We would like to ignore anything that has Bid in that cell

Thank you again for your help

Hi kvsrinivasamurthy i have just uploaded the file on the main post up above

Thank you again, your a star

Hey kvsrinivasamurthy

I was wondering if you could help me out again with the formulas you gave me before.
=IFERROR(INDEX('Doc List'!F$4:F$183,AGGREGATE(15,6,ROW('Doc List'!$F$4:$G$183)/( 'Doc List'!$I$4:$I$183<>"Not Sent"),1+INT(((ROW()-ROW($C$5)))/4))-ROW($G$4)+1),"")

On my first tab

I have all the information i need that i type in or use a drop down box to pick what i want. (This document is my testing document drop down boxes won't be on here)

In the phase part(First Tab, Column I) I have sent or not sent, this transfer all the date to another sheet called Second Tab.

On the Second tab it puts all the sent(First tab) dater into the table. But when i change Not sent to Sent, the text in the table(Second tab) all moves down. But i have other text in the table that needs to match that i have insert.

It hard to explain but when you look at the document and change Not sent to Sent you everything moved down in the table apart from the right hand side of the table with text in. Can any help me fix this please.

I have upload a new excle sheet, with comment inside to explain.

In the Frist tab Column F Text moves to Second Tab C
In the Frist tab Column G Text moves to Second Tab Column D
In Frist tab Column J Text moves to Second Tab Column B.

They only move across when you turn Column I (First Tab, Phase) to Sent.

As on the second Tab you see Test 1, Test 7, Test 8 & Test 14 in column D The text in columns F to N does drop down when you Add Test 2 in.

To add Test 2 in, If you go to First Tab go to Column I line I5 turn it to Sent and go back to Second Tab everything moved down

I have taken screen shoots for you