I'm trying to manipulate data to show the individuals in a company only on
one line. The most employees I will show is 64 (so I would have 64 blank
columns to the left of the company name).

On column A is the company name - so if I have 3 contact names for company
ABC, they would take up three rows. What I would like to do is show only
one company and have the names listed to the right of the company name all
on one row. After the names have moved, delete the extra rows.

Can someone help me with code to move the contacts to show only one company
with the different contacts.

(The contacts need to be in their own column as this spreadsheet will be
merged later into a Word document.)

Thanks for any help you can provide.

Annette