So whats the solution send lots of small ones
for core wallets.
1. Select options from your wallet and tick the box that says enable coin control features in the wallet section.
2. Go to the send tab in the main wallet GUI and select inputs and now you will be able to gather them manually by selecting them and the wallet will tell you how much it will cost you in charges. You will not be able to gather them all and send them but you will be able to gather hundreds of them, then just send them to yourself.
3. Repeat until you have as few inputs for the sums that you desire.
Awesome tip! I've spent the last hour to tidy up my transaction history. Thanks!