search for: 550ir

Dear all. I have data that looks like this: Biller Cycle Jan Feb Mar Apr May JuneAB 1 100 150 150 200 300 450JL 2 650 600 750 700 850 800JL 3 700 740 680 690 700 580IR 1 455 400 405 410 505 550IR 4 600 650 700 750 650 680IR 5 100 150 120 130 140 190IR 9 600 640 630 625 680 690 For each biller and cycle, I want to determine the six months average for Jan-Jun and also a 3-month moving average for Jan-Jun. If a cycle number is skipped such as cycle 1 for biller J...