Hi, I am working on an excel sheet and need some help.

I have data in the format of Part B on the attached image. I have only shown a few examples of the data, but I have 15+ various line items which all have different work items, descriptions, work orders, completion dates, etc.

I need to sort the data in various methods to include the actual cost based on car, location, type, etc. I believe pivot tables is the best tool to use to analyze the data. However, with pivot tables, I've found I need all of the data on 1 line like Part A of the attached image.

I will collect all future data based on Part A; however, I need to display the data in a format like Part B for a separate report.

I tried using VLookUp and the Match/index functions above, but I could not get it to work correctly.

Any help/ideas/etc? I would greatly appreciate it!

-Brooke