Looking for a better way to generate unique lists

A user has the following:
{"target","A","target","B","target","C";"a",1,"a",0,"b",1;"c",3,"b",1,"c",0;"d",0,"d",3,"e",1;"e",1,"f",2,"g",2;"g",3,"g",2,"h",1;"h",2,"h",1,0,0;0,0,"i",3,0,0;0,0,"j",0,0,0}

and wants to turn it into:
{"target","A","B","C";"a",1,0," ";"a",1,0," ";"b"," ",1,1;"c",3," ",0;"d",0,3," ";"e",1," ",1;"f"," ",2," ";"g",3,2,2;"h",2,1,1;"i"," ",3," ";"j"," ",0," "}

My strategy so far is cumbersome. I copy and paste each of the "target" columns into a single column, run an advanced filter for unique records, paste that to a new location, then use the new list to perform vlookups on the original table.

NE help would be much appreciated! Especially with regard to the generation of the unique list- is there a way to automate this?