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

Question

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.

Book (1).xlsx

20230315_153405.jpg

RobertOdera · Answer

Hi, @vishalnegi

I hope I understood your question correctly.

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

For_vishalnegi.yxmd

vishalnegi · Answer

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.

Book (1).xlsx

ShankerV · Answer

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