Hi,
I have an excel sheet with around 12,000 records. This is a database of a set of people. I have around 27 columns and 12,000 rows

I have the following issue

I have multiple entries of people with records having some data for e,g, three records of John Doe but one has an address one has a telephone number and one will have nothing.

How can I merge them such that 4 fields are the same, salutation, first name, last name and company name and records are merged in such a way that all data from rows are in a single record.

Thanks
Vijay

I am on a mac but can get access to a PC