PivotTable question about grouping numbers in it
in excel sheet i have a lot of numbers, and i want to do pivot table
from this numbers but to be sorted in some range of numbers and to see
it in pivot table in that range! example:
1,09-1,20
1,20-1,60
1,60-1,80
1,80-1,89
1,89-2,60 ....
so to have it all sorted in this kind of ranges and not like pivot data
is arrange by this intervals. Automatically data is now sorted like this:
1,09
1,1
1,11
1,12
1,13
1,14
1,15 .... which is too much rows in pivot table
|