Move data left into empty cell

This may be a repost as PC crashed whilst posting.
Anyway, here goes again...
Product details are in an Excel table.
Col "A" holds product names; "B" product number; "C" onwards is other data relating to the product but any of the data (from "C" onwards) on any row can be deleted when it is no longer relevant.
When a cell value is deleted, I want all other cell values to the right of the deleted cell on the same row to move one cell to the left. This will 'fill' the empty cell and ensure there's no wasted space in the table.

Would it be feasible to start at "B" and move one cell at a time to the right until a blank cell is found, move the data in the next cell to the blank one and keep looping until the next blank cell is found (I.e. the end of the row)?

What seemed like a straightforward request is proving to be a pain!