I receive large sales reports in Excel that I need to be able to convert to a list. The report is grouped by customer name and ID on a different line than the related records. I want to run a procedure that extracts the customer name and puts it on the same line as the invoice data. The goal is to get a list that can be used for pivot tables or import.
Here's the steps that I identified:
-Insert new COL A
-Extract Customer name from string
-Populate COL A with the Customer name associated with correct invoice records
-Delete empty rows, subtotals, and section headers
-Anything else that you see wrong.
Attached is a workbook with the bad data that I receive in one tab and the result I need in the other tab.
Thanks for your help experts!