Hi

I need help. I have want to separate one column into two. But I don't want
to sort or filter, I want to make two extra columns, so I can view the data
side by side, how do I do it?

eg
make

A 2 x
A 2 y
B 2 x
B 2 y

into
x y
A 2 2
B 2 2