I have data exported that requires to be reformatted like so:

x1 a
x1 b
x2 c
x2 d
to become
x1 a b
x2 c d
etc.
Can anyone steer me thru this.