How create a pivot table for this data.

OSLO TRAVEL AGENTS Country Resort Hotel Name of days Great Barrier Reef Santiago Perth London Baywater Toulouse Pans Nice Nice Perth 6 Australia Chile Australia England England France France France France Australia Australia Spain Spain Spain Spain Spain Spain Spain Spain Trinidad England Germany Chile 5 4 8 T9 Travel Holiday ID Method Plane CH2523H Plane AA 2369A Plane JAB4589B Train AC9841C Train CD1234D Coach CE6514E Plane CF5142F Plane EA0216A Plane EB9951B Coach EC7845C Coach PL1569 Train PQ74560 Train PR9945R Coach PS1203S Plane TA1278A Plane TB6521B Plane TC2018 Plane H147121 Coach HJ0369 Coach HK3081K Train WS9610S Train WT02877 Plane WU34120 Plane WV6510V Plane 0064120 Plane OU88320 Price for Stay$ $ 145.00 $ 131,00 $ 130.00 $ 141.00 $ 137.00 $ 135.00 $ 141.00 $ 145.00 $ 125.00 $ 120.00 $ 98.00 $ 95,00 $ 93.00 $ 100.00 $ 103.00 $ 107.00 $ 109.00 $ 95.00 $ 111.00 $ 120.00 $ 141.00 $ 150.00 $ 135.00 $ 132.00 S 130.00 S 127.00 Perth Seville Madrid Malaga Toledo Granada Barcelona Barcelona Madrid Port of Spain Baywater Meininger Santiago Santiago Copenhagen Copenhagen I 11 5 13 1 Chile Denmark Denmark