Group rows then pull back row data

[Anonymous]

Ok someone once helped me with this but i've clean forgotten how to do it because it's quite technical.

I need to group data based on Member ID, by the latest date. This creates a list of Unique Member IDs. But in order to do this, I need to remove the Index else it won't focus just on grouping Member ID. But then once I've done this, I want the Index associated with the saved rows, to come back. 

How do I do this? 

[TeigeGao]

Hi @Anonymous ,

Could you please share some sample data and expected result to us for analysis? 

Best Regards,

Teige

[Anonymous]

Hi @TeigeGao 

Sure thing, I can't upload data - this forum doesn't let me - so i've drawn a pretty picture instead I hope it makes sense!