How can you consolidate your personal UTXO set? (different wallet answers welcomed)
I thought this would be as simple as spending the full wallet amount to a new receiving address for the same wallet, and watch as the two inputs were combined into two outputs. However when I did this the wallet simply spent to two outputs of the same amount (minus a tiny fee) regardless


That is exactly what you are supposed to do. That it didn't work means that you did not specify the amount correctly. This could be because you either calculated the amount incorrectly or there is a software bug. I'm leaning towards the former.

If you calculated your amount by looking at a blockchain explorer, don't do that. It will result in an accurate balance calculation because of change addresses. Instead you should just use what your wallet reports back to you.

Most wallets have an option to send the maximum amount in a wallet. If your wallet has that option, use it instead of manually entering the amount. This will guarantee that your entire balance is sent to a single UTXO.