pivot table unique rank by most recent date

Hello. I have three fields, keywords, rannk, and date.



A keyword can have multiple dates and corresponding ranks.



For example, dog bone, 1/1/18, 1........dog bone, 1/4,18, 2



How can I pivot table the words and see the rank by keyword for the MOST RECENT date (so just a list of all unique words with the rank for the most recent date, and if there are no dates for a keyword, then just return the date).