Dataset issue

I have an excel sheet that i have 2 columns for, the problem i am having is trying to look up the data for a particular number, i have tried a pivot table but it does not give me the correct data from the cells, here is an example of the data i am trying to mine. i would eliminate the dups but that would be a manual process, i need the data from the 2nd column to show up using some type of lookup in to 3 columns, for example: Column A = 10504924, Column B = 630650, Column C = 630650 and so on, as you can see the data below can have different column B and C data based on Column A. Not all the column A's have a 2nd number for column C to to fill so a "0" value is fine