Excel group pivot table percentages (VBA)

[witchcraftz]

My pivot table data is a simple list of percentages, it is similar to the list below:

0%
10.01%
8%
100%
80%
20.2%
100%
90%
50%
6.6%
48%

I want to group the data this way:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Percentage[/TD]
[TD]Count[/TD]
[/TR]
[TR]
[TD]100%[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]75% to <100%[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]50% to <75%[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]25% to <50%[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]0%> to <25%[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]0%[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]


I have read a some posts but I'm not sure how to do this.

The closest is this post but the grouping is wrong and my mind is having a hard time figuring out how to modify this for my purposes.

https://stackoverflow.com/questions/46912874/pivot-table-grouping-percentage-ranges-using-vba