I have a worksheet that I would like to change all rows to columns -- a
pivottable would work perfectly if text could be shown in the data area. Is
there a way to do this? If not, my table has 3 columns:

Key Code Country Text
Code 1 US xxxxxxxxx
Code 1 China xxxxxxxx
Code 1 UK xxxxxxxxxx
Code 2 US xxxxxx
Code 3 China xxxxxx
Code 3 UK xxxxxx

I want change the table to be

Code US China UK
1 xxxxxx xxxxxx xxxxxx
2 xxxxxxx
3 xxxxxx xxxxxx

Can someone tell me how that can be done???

Thank you!