Question: how to copy and paste from pdf to excel and keep formatting?
Answer: Step 1: Open the relevant PDF file and select and copy table. ...  Step 2: Copy this into Word and convert to a table. ...  Step 3: Paste this into Excel. ...  Step 4: Manipulating the Excel table. ...  Step 5: Working out average inflation for the whole period.