Formulas to move cell contents to new position

[j_Southern]

I have a table relating two sets of values which I wish to use as a lookup table. My problem is that the second column has a variable number of repeats of its values. both VLOOKUP AND INDEX/MATCH will relate to the first value in the lookup column, and this usually gives a blank as the looked up value.
I am searching for a way to move the values in the first column so that they line up with the first instance of each of the values in the second column.
This very difficult to explain, but easy to illustrate so please look in the attached workbook!
I hope that someone vcan help me.
John

[j_Southern]

Sorry the download seems to have lost the table showing what I would like to happen. Test11.xlsm should show what I need

[samba_ravi]

simply sort the data

[JohnTopley]

In F2

=IF($A3<>"",$A3,"")

copy down

in G2

=B2

[j_Southern]

John Topley,
A belated thank you for your help. I had gone down the sort route suggested by nflsales. I,ll try yours now.
John