Merge Duplicates with Different Partial Data??

I'm not sure if Excel can do this and if not, maybe there is another tool that can.

I have a CSV file with 1M company records. There are many partial duplicates. What I mean by 'partial' is that one record may have...

Company
First Name
Phone
Website

And the other may have

Company
Address
Phone
Website

And another may have

First Name
Last Name
Email
Phone

Is there a way to merge that data together without losing any of it? So that after I merge, I have one record with these fields.

Company
First Name
Last Name
Address
Phone
Email
Website

All of these are in the same CSV file. NOTE: There are about 20 columns. 1 Company, 1 First Name, 1 last Name, etc.

I am trying to have a program custom built for this step but it is not going as smooth as expected.

Any help will be greatly appreciated.

Thanks.