I want the following output as my query. anyone please can you help me

Question

Hi all,

 

I am getting the below output after the querying.

 

But i want output like below , the output only need to show the result latest ProducttranEnd for each Vendor code. Please anyone can help me in this.

 

Thanks and reg