I have a spreadsheet that has multiple rows per person based on medical, dental, and vision coverage. I want to combine all rows for the same person into one row.

For example:

The existing spreadsheet looks like:

ssn name address coverage

111 smith 123 main medical group 1
111 smith 123 main vision 2-party
111 smith 123 main dental PPO



I want it to look like:



ssn name address medical vision dental

111 smith 123 main medical group 1 vision 2-party dental PPO




Any ideas?