vba - Select values based on the values of the first column -

i have database looks this:

name    -finding 1    -finding 2    -finding 3  john    -low cost        john    -accessible     -low cost    michael -high cost      -good quality   -good csr  michael -low cost       -friendly csr    michael -average cost        michael -lot of features    -good quality    charles -average cost        bryan   -high cost      -friendly csr    

as can see, have same guy working different accounts , reporting on findings.

i need findings per worker , put them in different columns, can remove duplicate values (for example, john found "low cost" in 2 different accounts - need listed once). and, once i've removed duplicates, need put remaining in 1 cell (as string of text) - per installer (not overall conglomerate).

please help. i'm new in vba.

note on side: started separating installers macro (thinking leaving space in between installers work out rest - i've worked little success in finding solution this).

is looking ?

sub sample()       dim lastrow long     lastrow = range("a" & rows.count).end(xlup).row      range("a2:b" & lastrow).copy range("f1")     range("a2:a" & lastrow).copy range("f" & rows.count).end(xlup)     range("c2:c" & lastrow).copy range("g" & rows.count).end(xlup)      range("a2:a" & lastrow).copy range("f" & rows.count).end(xlup)     range("d2:d" & lastrow).copy range("g" & rows.count).end(xlup)       lastrow = range("f" & rows.count).end(xlup).row     range("f1:g" & lastrow).removeduplicates columns:=array(1, 2), header:=xlyes  end sub