Address Ranges Help Needed

I have data base with 4 columns of address numbers for each street name. Need to only have "one" street name with lowest to highest number range. See attached file...., I would have the answer of : Beverly Hill St 9500 - 9699

Thanks Rich ><>