I solved this in Excel using PowerQuery. It can be done using VBA too, but I'm no guru there. Now, I have my trade report automated with one for split trades and one for aggregated trades. All set up to my own preferences.