How to delete rows between two table in excel without disturbing template and output the s

[vishalnegi]

I need to 

a. Remove the row gap between two tables in a template i.e. Row 10 and row 11

b. Output result without distrurbing the existing template into a new excel

P.s. To remove the gap i used the formula tool through !IsNULL ([Date]) but was unable to preserve the existing template of imported sheet.

[ShankerV]

Hi @vishalnegi 

I could see the same format is maintained.

If you are expecting a different output, please share the expected output.

Many thanks

Shanker V

[vishalnegi]

Thank you for answering the query. When i am creating output it is disturbing the template for this sheet..

In the sheet i need to delete rows 13 and 14 and then output the file as well.

[RobertOdera]

Hi, @vishalnegi 

I hope I understood your question correctly.

Try the below, and please mark it as a solution if it works for you.