Just an update i was able to recreate the pivot table myself, and i did it on Sheet 2. All i need now is to accomplish my 2nd requirement. to determine the Client Name of each deployed equipment.