hello!
My data looks like this

Name City
Amer RWP
Amer PSH
Amer MIA
Amer MUL
Nadeem ISB
Nadeem LHR
Nadeem DGK
so on.....

i want to form a pivot as under:

Amer RWP PSH MIA MUL
Nadeem ISB LHR DGK
so on.....
Plz guide.

Thanks