Extract unique values in a column from a table

I got a datafile with about 50000 rows of data where in column A there is a ID number and in column B there is a dateformat as the following, yyyyww, for example 201705 which is week 5 in the year 2017. In column A there will the same ID number appear in several rows but I only want to have one row per ID number. Therefore I need to extract all unique values in column A with each corresponding column. When a ID number has a duplicate then I only want to see the ID number with the earliest date in column B. Its possible to sort column B from the first date to the last if that helps. Anyone know how I can solve this?

Hi,
Please attach slamm sample file with dummy data, but make sure the structure of file is the same as your original file.

I tried to use a code from one of my previous projects which I think someone in here helped me with. I changed the code a bit and it looks like its working as intented but then I found out that it apparently still is a couple duplicates in column 5, did I miss something when I changed my code?

Please Login or Register  to view this content.