Formula dates on in and out equipment.

HI Everyone,


I am not sure how this works, but i'll give it a try here. So, I have a spreadsheet where I need to keep track of dates. My goal is to know when equipment comes in and when it gets delivered back to the customer BUT at the same to be easy on the eye wnen reviewing. i am interested in showing the dates of when it got shipped to the vendor and when it got back from the vendor.




How can i show on a pivot table the dates of the customer with the dates pertaining to the record?. i need the dates to show, but i want the dates to show the column header. not just a random date.


thanks