I have a table with similar to that shown below

Col1 Col2 Col3 Col4 Col5

i want to display the data in this form

Col2 Col3 Col4 Col5
Col1

How do I do this with a Pivot Table?

Thanks,
Barb Reinhardt