Pivot table to display column header detail where there is a count/result

Hi there,

I'm trying to get a pivot table to display the column header details in my data where there is a result. My pivot table is working from order numbers assigned to a list of product codes. Within this data there are duplicate order numbers with different component codes that make up the overall product code. I have arranged my pivot table to display the product codes down the left (Y axis) with the component codes running across the X axis. The component codes vary across the product codes. I would like my pivot table to display the header component code (relative to that column) where there is a returned result/count from this data. The reason I'm after this is because I don't currently have access to Microsoft Access to perform this as I normally would in so I'm having to do a double vlookup to reference the correct column number component code in a separate sheet. I have this working for a significantly smaller amount of data however I'd like to be able to do this without all the copying & pasting I had to do to get it to work.

Any advice would be appreciated, I'm sure it must be possible but I'm just not sure how I go about doing it, surely it should be relatively simple and obviously easy when you know how!!?

Of course Richard you're quite right, I've attached the file and it's a much simplified. In my pivot table I'd like wherever a count appears to display the header of the column, i.e. the component code. Any ideas on how to do this would be much appreciated.