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



I have data in the format of the Part B on the attached image. I have only shown 2 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 shown in Part A.

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

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

Attached Images

Excel Help.jpg (111.2 KB, 32 views)