How To Group By Range In An Excel Pivot Table with big data

[Judith012604]

Dear community,

I cannot use groupe option by range on a pivot table with 2500 lines 

Do you know why? Is there a workaround? 

Thanks for your support!

Judith

[#2]

Grouping by range is allowed on numeric data. Make sure the column contains the numeric data type. Sometimes the content of a column looks like numeric but it is actually numbers stored as Text.