REMOVING ALL HIERARCHY FROM SHEET
I'm using a sheet (Grid view) that I initially needed Parent and child rows on, but we have decided we would like a simpler format. I don't want to delete my sheet and start over because I need all the current data as I am still using it. BUT I want to go back thru the sheet and re-format it without the parent/child hierarchy + and - every time I click to indent or outdent (attempting to get rid of them) they just move to the next line on the sheet. Is there a way to completely remove it all without them just moving around?