Data Restructuring: Using Pivot Table w\o the SUM, COUNT etc. Function?

Hello to all,

I'm just wondering if someone could help me with this issue.

I have the following:

Please Login or Register  to view this content.

I want to Transpose the above table to look like the following:

Please Login or Register  to view this content.

I've tried using a pivot table but I cannot get around the issue whereby when I drag over the Call code column into the Data space it automatically wants to carry out a Function on my text data (call code column).

What I hope to do is use the pivot table technique to just click & drag my text data over as is, without having the pivot table try and calculate some function.

Is this possible within Excel? Or should I be using another procedure within Excel to accomplish this?

Thanks very much for any help I can get!