Spreadsheet: 103469d1301224827-pivot-problem-pivot-sort-problem
Sheet: pivot

 |  | Valuation
 |  | Account Number | (All)
 |  | Account Name | (All)
 |  | Sector Description | Stock Description | Currency | Current Price | Holding | Purchase Cost | Current Value £ | Percentage of Total Value | Gross Income £ | Yield%
 |  |  |  |  |  |  | Values
 |  | Sector Description | Stock Full Name | Price_Currency2 | Price USED | Holding
 |  | Bonds | XXX30 | GBP | 52 | 2500 | 3010 |  |  |  | 0
 |  |  | XXX31 | GBP | 56 | 2550 | 3011 |  |  |  | 0
 |  |  | XXX32 | GBP | 60 | 2600 | 3012 |  |  |  | 0
 |  |  | XXX33 | GBP | 64 | 2650 | 3013 |  |  |  | 0
 |  |  | [NAME] | GBP | 68 | 2700 | 3014 |  |  |  | 0
 |  |  | XXX35 | GBP | 72 | 2750 | 3015 |  |  |  | 0
 |  |  | XXX36 | GBP | 76 | 2800 | 3016 |  |  |  | 0
 |  |  | XXX37 | GBP | 80 | 2850 | 3017 |  |  |  | 0
 |  |  | XXX38 | GBP | 84 | 2900 | 3018 |  |  |  | 0
 |  |  | XXX39 | GBP | 88 | 2950 | 3019 |  |  |  | 0
 |  |  | XXX40 | GBP | 92 | 3000 | 3020 |  |  |  | 0
 |  |  | XXX50 | GBP | 132 | 3500 | 3030 |  |  |  | 0
 |  |  | [NAME] | GBP | 216 | 4550 | 3051 |  |  |  | 0
 |  | Bonds Total |  |  |  |  | 39246 |  |  |  | 0
 |  | Equities | XXX20 | GBP | 12 | 2000 | 3000 |  |  |  | 0
 |  |  | XXX21 | GBP | 16 | 2050 | 3001 |  |  |  | 0
 |  |  | XXX22 | AUD | 20 | 2100 | 3002 |  |  |  | 0
 |  |  | XXX23 | USD | 24 | 2150 | 3003 |  |  |  | 0
 |  |  | XXX24 | GBP | 28 | 2200 | 3004 |  |  |  | 0
 |  |  | XXX25 | GBP | 32 | 2250 | 3005 |  |  |  | 0
 |  |  | XXX26 | GBP | 36 | 2300 | 3006 |  |  |  | 0
 |  |  | XXX27 | GBP | 40 | 2350 | 3007 |  |  |  | 0
 |  |  | XXX28 | GBP | 44 | 2400 | 3008 |  |  |  | 0
 |  |  | XXX29 | CAD | 48 | 2450 | 3009 |  |  |  | 0
 |  |  | XXX42 | GBP | 100 | 3100 | 3022 |  |  |  | 0
 |  |  | XXX43 | GBP | 104 | 3150 | 3023 |  |  |  | 0
 |  |  | [NAME] | USD | 108 | 3200 | 3024 |  |  |  | 0
 |  |  | XXX45 | GBP | 112 | 3250 | 3025 |  |  |  | 0
 |  |  | XXX46 | USD | 116 | 3300 | 3026 |  |  |  | 0
 |  |  | XXX47 | GBP | 120 | 3350 | 3027 |  |  |  | 0
 |  |  | XXX48 | CAD | 124 | 3400 | 3028 |  |  |  | 0
 |  |  | XXX49 | GBP | 128 | 3450 | 3029 |  |  |  | 0
 |  |  | XXX51 | GBP | 136 | 3550 | 3031 |  |  |  | 0
 |  |  | XXX52 | CAD | 140 | 3600 | 3032 |  |  |  | 0
 |  |  | XXX54 | GBP | 148 | 3700 | 3034 |  |  |  | 0
 |  |  | XXX55 | GBP | 152 | 3750 | 3035 |  |  |  | 0
 |  |  | XXX56 | USD | 156 | 3800 | 3036 |  |  |  | 0
 |  |  | XXX57 | NOK | 160 | 3850 | 3037 |  |  |  | 0
 |  |  | XXX58 | USD | 164 | 3900 | 3038 |  |  |  | 0
 |  |  | XXX59 | USD | 168 | 3950 | 3039 |  |  |  | 0
 |  |  | XXX60 | EUR | 172 | 4000 | 3040 |  |  |  | 0
 |  |  | XXX61 | CAD | 176 | 4050 | 3041 |  |  |  | 0
 |  |  | XXX62 | GBP | 180 | 4100 | 3042 |  |  |  | 0
 |  |  | XXX63 | HKD | 184 | 4150 | 3043 |  |  |  | 0
 |  |  | XXX64 | GBP | 188 | 4200 | 3044 |  |  |  | 0
 |  |  | XXX65 | USD | 192 | 4250 | 3045 |  |  |  | 0
 |  |  | XXX66 | CAD | 196 | 4300 | 3046 |  |  |  | 0
 |  |  | XXX67 | USD | 200 | 4350 | 3047 |  |  |  | 0
 |  |  | XXX68 | USD | 204 | 4400 | 3048 |  |  |  | 0
 |  |  | XXX69 | SGD | 208 | 4450 | 3049 |  |  |  | 0
 |  |  | XXX70 | GBP | 212 | 4500 | 3050 |  |  |  | 0
 |  |  | XXX72 | USD | 220 | 4600 | 3052 |  |  |  | 0
 |  |  | XXX73 | USD | 224 | 4650 | 3053 |  |  |  | 0
 |  |  | XXX74 | USD | 228 | 4700 | 3054 |  |  |  | 0
 |  |  | XXX75 | USD | 232 | 4750 | 3055 |  |  |  | 0
 |  |  | XXX76 | USD | 236 | 4800 | 3056 |  |  |  | 0
 |  |  | XXX77 | NOK | 240 | 4850 | 3057 |  |  |  | 0
 |  |  | XXX78 | USD | 244 | 4900 | 3058 |  |  |  | 0
 |  |  | XXX79 | GBP | 248 | 4950 | 3059 |  |  |  | 0
 |  |  | XXX80 | GBP | 252 | 5000 | 3060 |  |  |  | 0
 |  |  | XXX81 | AUD | 256 | 5050 | 3061 |  |  |  | 0
 |  |  | XXX82 | CAD | 260 | 5100 | 3062 |  |  |  | 0
 |  |  | XXX83 | CAD | 264 | 5150 | 3063 |  |  |  | 0
 |  |  | XXX84 | AUD | 268 | 5200 | 3064 |  |  |  | 0
 |  |  | XXX85 | GBP | 272 | 5250 | 3065 |  |  |  | 0
 |  |  | XXX86 | GBP | 276 | 5300 | 3066 |  |  |  | 0
 |  |  | XXX87 | CAD | 280 | 5350 | 3067 |  |  |  | 0
 |  |  | XXX88 | CAD | 284 | 5400 | 3068 |  |  |  | 0
 |  |  | XXX89 | USD | 288 | 5450 | 3069 |  |  |  | 0
 |  |  | XXX90 | USD | 292 | 5500 | 3070 |  |  |  | 0
 |  |  | XXX91 | USD | 296 | 5550 | 3071 |  |  |  | 0
 |  |  | XXX92 | GBP | 300 | 5600 | 3072 |  |  |  | 0
 |  |  | XXX93 | GBP | 304 | 5650 | 3073 |  |  |  | 0
 |  |  | XXX94 | GBP | 308 | 5700 | 3074 |  |  |  | 0
 |  |  | XXX95 | CAD | 312 | 5750 | 3075 |  |  |  | 0
 |  |  | [NAME] | CAD | 316 | 5800 | 3076 |  |  |  | 0
 |  |  | XXX97 | CHF | 320 | 5850 | 3077 |  |  |  | 0
 |  | Equities Total |  |  |  |  | 191703 |  |  |  | 0
 |  | Alternatives | XXX53 | GBP | 144 | 3650 | 3033 |  |  |  | 0
 |  | Alternatives Total |  |  |  |  | 3033 |  |  |  | 0
 |  | Delisted | XXX41 | GBP | 96 | 3050 | 3021 |  |  |  | 0
 |  | Delisted Total |  |  |  |  | 3021 |  |  |  | 0
 |  | Cash | Cash A/c - 10 | GBP | 1 |  | 170419.41 |  | 4.22 | 0 | 0
 |  |  | Cash A/c - 11 | GBP | 1 |  | 5849.76 |  | 0.14 | 0 | 0
 |  |  | Cash A/c - 1 | USD | 1.626 |  | 5417.05 |  | 0.08 | 0 | 0
 |  |  | Cash A/c - 1111 | EUR | 1.163 |  | 473.27 |  | 0.01 | 0 | 0
 |  |  | Cash A/c - 17 | EUR | 1.163 |  | 0.01 |  | 0 | 0 | 0
 |  |  | Cash A/c - 18 | CAD | 1.5867 |  | 745.24 |  | 0.01 | 0 | 0
 |  | Cash Total |  |  |  |  | 182904.74 |  | 4.459999999999999 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  | Total |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  | Totals |  |  |  |  | 419907.74 | 0 | 4.459999999999999 | 0 | 0