In the Tiller Community extension, under Tools, you’ll find a Rename Category workflow. This will allow you to either rename all the transactions in a category, or merge one category into another. The Categories sheet will be updated with any name change. These two processes should accommodate most situations.
Otherwise, sort or filter the Transactions sheet by Description or Category, then copy/paste updated categories names. Just make sure your Categories sheet reflects any name changes.