I have a data set where it contains customers and no of days columns
D 123 ETC ETC
I want to be able to group the days in 30 day increments (0 to 30 then 61 to 90 .. all the way to 1000) - this could be a very long Case statement. Is there another succinct way?
Customer Days Grouping
A 5 0 to 30 ETC ETC