Product Software List

[gazza1]

Hi, I am hoping someone can help me on this issue. I have a list of products with the version and release date in two columns:

Column1 Column2
Product v4.1.0 24th January 2014
Product 1 v5.1.2 20th Mach 2014
Product 2 v2.1.2 25th Jan
Product 3 v2.5.0 30th Jan
Product 3 v5.1.1 29th April
Product 4 v4.3.1 etc
etc
etc

Is it possible to take the information into a pivot table (or a list) but only show the latest software version for each product? i.e. above wold be:

Product 1 v5.1.2
Product 2 v2.1.2
Product 3 v5.1.1
Product 4 v4.3.1

Thank