Hi guys,
I've racked my head and the internet and i'm coming up blank.
I've attached an example of my data set, Rows 1 to 15 are my input, and 20 to 29 are the desired output.
I have a set of data with multiple records under one Identifier (property Code), and need to only return the most recent Landlord and most recent tenant for each property code.
Any ideas most welcome!
Thanks,
Matt
Bookmarks