How to delete rows between two table in excel without disturbing template and output the s
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @vishalnegi
I hope I understood your question correctly.
Try the below, and please mark it as a solution if it works for you.