Hello, I haven't been able to find a great way to do this so I wanted to ask around.

What I have:

ID Data1
1 A
1 B
2 C

What I need:

ID Data1 Data2
1 A B
2 C

Does anyone know of an automated way to do this? Please note, some rows have duplicates and some do not (leads me to think a macro wouldn't be the best way to do this)