Transposing Last record for Key Record

[Venky_1992]

Hi

I am sharing the input and how I am looking for the output for one of my use case
I am trying to fetch the last value from column B for every A value of Column A

Could anyone help!

[binuacs · Accepted solution]

@Venky_1992 one way of doing this