I have a list of contacts where column's A-J have company information (name, address, web site, etc).
Then columns K-??(different for each) holds contact people for that company. Each contact person for a company has 4 columns (Contact, title, phone, email) but since each company has a different number of contacts the information may run out to column "N" or to column "CC", which is my furthest column out.
What I would like to do is to combine the information on the sheet so that each Contact for a company has a unique record that includes their information (Contact, title, phone, email) and the company information.
Any ideas on how to merge the company information for each unique contact I have for that company?
Thanks in advance!
Then columns K-??(different for each) holds contact people for that company. Each contact person for a company has 4 columns (Contact, title, phone, email) but since each company has a different number of contacts the information may run out to column "N" or to column "CC", which is my furthest column out.
What I would like to do is to combine the information on the sheet so that each Contact for a company has a unique record that includes their information (Contact, title, phone, email) and the company information.
Any ideas on how to merge the company information for each unique contact I have for that company?
Thanks in advance!