Problem with huge blank spaces in table rows in Pages on Mac

Im working on a script in a table form in Pages. I accidentally added a couple of extra columns and since this happened all my cells have huge blank spaces after the last bit of text. I show invisibles but there is just a dot so there's no joy there...

I untick the "resize rows to fit cell contents" but then this means I have to manually resize the rows and sometimes it won't allow me to do this beyond a certain point therefore now showing all the of the text.

If I tick The resize rows to fit cell contents option it then goes back to having the massive space on every row. Please can someone suggest a fix? I cannot see how I have done this, as I only created some columns then clicked undo to remove them. Thanks in advance.