Extract data from Pivot Table (If statement & GetPivotdata)

Hi All,

I'd like to extract some data from a pivot table if a cell matches another cell. For example, if a particular company offered sale, I want to list all the years they had sale in. I have a pivot table where the Company numbers (titled 'Company') and years (titled 'year') are in the Report Filter section.

Then, in an excel tab I have the following:

Company	Year	Sale
1		sale
2		no sale
3		sale

So, in column 2 I would like to have a formula/function stating, if Column 3 says sale then copy the years for company in column 1 from the pivot.

So, I'd get something like below:

Company	Year	Sale
1	2012, 2013, 2014	sale
2		no sale
3	2014, 2015	sale

Can you upload a sanitized sample file? Might be easier to pull the info from the data, instead of the pivot table. But we need to see how it's organized.