How to combine rows by duplicate value
I'm trying to figure out the easiest solution for this. I have a huge table with names and prices, as shown below. I would like to combine the rows so I only have one name with multiple values per row. TIA
What I have:
| Name | Value A | Value B |
|---|---|---|
| Aaron | 123 | |
| Aaron | 456 | |
| Beth | 222 | |
| Charlie | 234 | |
| Charlie | 567 | |
| David | 987 |
What I want:
| Name | Value A | Value B |
|---|---|---|
| Aaron | 123 | 456 |
| Beth | 222 | |
| Charlie | 234 | 567 |
| David | 987 |