Only filter 'keys' with multiple a car purchase and at least one service

[OwaisYounus]

Hi 

I have a data with 3 columns i.e Key, date and Service. I am trying to filter the keys that has Car purchase and at least one service. Looking for help. Thanks

[suby]

Hi,

Can you post the Data rather than copying it.

It will make easier for the experts in the forum.

Thanks

[Qiu]

@OwaisYounus 
The data would be much better.
below is one sample.
We can concantate the "Service" then do a filtering as below.

[OwaisYounus]

Thanks for the quick responses. Here's the data as requested.

[OwaisYounus]

Here's the data