And highest if the cells are now 3, Code, name, amount. Amount are separate to allow for further calculations.
Why would anyone on earth want account code to be in different columns, to sum up the codes? it hard for me to think of anything in this world that would make anyone want that.
Well I won't continue on this anymore, there are so many requests here, some useful for everyone, some useful for only the one.
My advice, use split cells in your spread sheet