I am trying to map data from one worksheet to another. All the data is in
text format and appears like this:

A B
x ab
x cd
y af
y cw
y te
z re

I want to map it to a different worksheet so that it appears like this

x ab cd
y af cw te
z re

So that for each of the items in the first coulumn of the first worksheet it
displays the different sets that correspond to it in the same row in the
second worksheet. I tried to use pivot tables but they only work with numbers
I guess. Please help ASAP.