Deleting duplicates but moving the data to another cell

Ok, so we have one worksheet With 3 col. & 1000 rows

Col1 has product sku
col 2 has Categorys
Col 3 is Price

What I am trying to do is take col 1 and remove the duplicates but take the information and add it to col 2. for example


COL1 COL2 COL3
9559 Networking 19.99
9559 Computers 19.99
9665 Computers 27.99
9667 Hardware 199.95
9667 Computers 199.95



This is what I would like for it to look like

COL1 COL2 COL3
9559 Networking | Computers 19.99
9665 Computers 27.99
9667 Hardware | Computers 199.95


I hope I have explained this enough if not then let me know and I will try to explain it some more.

Here you go. The shortened list in F:H.

F1 has a unique formula, array entered (Ctrl-Shift-Enter)
F2 and down share a formula, array entered
G1 and down use an installed UDF to string concat, array entered
H1 and down is a simple match