Short answer: the best way to do this is to use the facilities for that in your chosen spreadsheet program (LibreOffice, Microsoft Excel, etc.).
Explanation: lots of our customers have opinions on the importance of including other columns (calculated from the existing ones), or filtering them, or sorting them. And of course, they are all correct: if they want this, then it should be done! The thing is, though, that they don’t all agree with each other – each has their own needs for their own situation. However, this does not need to be a problem. The detailed CSV exists precisely because it can be manipulated exactly as you desire. It comes out of the VAT plugin in a raw form; you can then calculate, filter or sort it just as needed for your situation.
Posted in: WooCommerce EU/UK VAT Compliance