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?