combine column data into a row

S

SMC

I am attempting to email clients that have mulitiple patients (animals).
Instead of sending each client numerous emails I would like to combine the
patients into one email. Is there a way to combine the names that show up in
different rows into one row?
 
Top