A low-tech vendor sends me reports in Excel with the customer name and ID on a different line than the related records. I want to run a procedure that puts the information identifying the customer on the same line as the invoice data. In other words, I need to tag the invoice data with the customer ID from Col B and the Customer name from COL D. The goal is to get a list that can be used for pivot tables or import.
Attached is a workbook with the bad data that I get in one tab and the result I need in the other tab.
Thanks for your help experts!