Good question, @alan.heatherley. I’ve had to do this a number of times.
It’s manual but I think the approach @heather recommends here is the best way. It’s quick and you have full control.
She suggests normalizing just the Account Id, but personally I would do it for several columns (Account, Account #, Institution, etc).