Desperately finding a solution to delete rows in Collections

I think it is a permission thing, maybe you have setup permission to not permit DELETE. Right click your Data Collection and make sure you have the correct permissions.