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.
Now, I have my trade report automated with one for split trades and one for aggregated trades. All set up to my own preferences.