I have a spreadsheet which has some single columns of numbers which i want to pivot (rather than using COUNT) to show occurrences of entries.
But the pivot table is just repeating the values. I am dropping the column header into ROW and VALUE. The point is also that i know for example that there are two or three occurrences of the zero entry so my guess was that the right hand column would reflect that.
<tbody>
</tbody>
Whats going on here.....?
But the pivot table is just repeating the values. I am dropping the column header into ROW and VALUE. The point is also that i know for example that there are two or three occurrences of the zero entry so my guess was that the right hand column would reflect that.
0 | 0 |
2 | 2 |
3 | 3 |
6 | 6 |
8 | 8 |
15 | 15 |
25 | 25 |
35 | 70 |
40 | 40 |
43 | 43 |
61 | 61 |
62 | 62 |
64 | 64 |
67 | 67 |
70 | 70 |
72 | 72 |
79 | 79 |
95 | 95 |
129 | 129 |
150 | 150 |
270 | 270 |
330 | 330 |
661 | 661 |
668 | 668 |
801 | 801 |
1061 | 1061 |
1290 | 1290 |
2136 | 2136 |
4360 | 4360 |
<tbody>
</tbody>
Whats going on here.....?
Last edited: