Hello i have a query that spits out this (image attached)
how do i make it so that if the duration is between 1-5, then turn that number into a "5" and the values "number of sites" on the second column should all add together.
for example if 'Duration' values are 1,2,3, (as in pic), then combine the rows and turn duration into a "5". the number of sites it corresponds to should be 59+18+11, spitting out "88". so the row should now read "5" for Duration" and "88" for number of sites. I want to do this in counts of fives, so Duration can only be 5,10, or 15
let me know if i need to be more clear. thanks