We have an attribute for some of our products that has hundreds of empty values. If you try to make and save any changes to any values, it kicks you back out to the dashboard and the changes are not saved. Is there a way to delete all empty values without deleting the entire attribute?
Over a year later and I am still dealing with this issue, I have tried using the query mentioned here: https://magento.stackexchange.com/a/16123/100539, but did not get any results. Does anyone have another query I can try or another method around this?
I figured it out, see my answer below.