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

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.

[MeganBowers]

Hi! Just wanted to clarify--are you looking to do this in Designer or Designer Cloud? 

[vishalnegi]

designer

[MeganBowers]

@vishalnegi I've moved your post into the Designer discussion forums so that you can get the help you need! I would also recommend looking at this blog to see how you can use the blob tool to preserve formatting in Excel files: https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/...