Excel Spreadsheet Automation

A report is run from our internal accounting software into an Excel format (this original report has been attached and is labelled Raw Data). Because this report is sent off to a supplier and they require it in a specific format, our staff complete the following changes which result in the second attached Excel sheet (labelled Finished Product). Merge B2 to A2 Merge B3 to A3 Merge the B33 cell to the end of A4 Moves A33 to A5 (overwriting whats in the cell) Manually goes through each barcode and removes the first 0 but only if there are 2 x 0's. If there is only one, this is left A line is always added at the end with the same information... the A column will have ZL54000 and the H column will have $6.50 The attached examples are small reports - most usually go into the 1000's so you can see how this might waste some time. The Raw-Data sheet is how the report is generated and the finished product shows how it needs to look at the end. The automation would need to be dynamic in the sense that it could work with 1000's of lines. We would also require the addin/macro to work on Excel 2010.