# Delete an item from a table using glide delete leaves blank row

**URL:** <https://community.glideapps.com/t/delete-an-item-from-a-table-using-glide-delete-leaves-blank-row/39764>\
**Category:** Ask for Help\
**Created:** [March 17, 2022, 3:38am UTC](https://community.glideapps.com/t/delete-an-item-from-a-table-using-glide-delete-leaves-blank-row/39764 "2022-03-17T03:38:22Z")\
**Posts on this page:** 1\
**Showing post:** 18

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 21, 2022, 3:51am UTC](https://community.glideapps.com/t/delete-an-item-from-a-table-using-glide-delete-leaves-blank-row/39764/18 "2022-03-21T03:51:13Z")

</div>

Here’s some sample apps script that can be used to clean up empty rows left by Glide.

> [@Minor bug/inconsistency on API](https://community.glideapps.com/t/minor-bug-inconsistency-on-api/39744/10):
>
> There is, but at the moment it’s only available to Enterprise customers. I use a bit of apps script for this. Here’s an example you could adapt: function remove\_empty\_rows() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheetByName('YOUR SHEET NAME GOES HERE'); var headers = sheet.getRange(1,1,1,sheet.getLastColumn()).getValues().shift(); var concat\_index = headers.indexOf('CHANGE THIS'); var uuid\_index = headers.indexOf('CHANGE THIS ALSO'); var data = sheet…

Also, unless you absolutely need the computed data in the spreadsheet, I’d encourage you to investigate the option of getting rid of the spreadsheet formulas, and replace them with Glide computed columns.

---

_[View the full topic](https://community.glideapps.com/t/delete-an-item-from-a-table-using-glide-delete-leaves-blank-row/39764)._