Trying to write a Loop to perform calculations within blank rows between populated rows

Good morning, John H Davis. I tried your code today, and the first loop (for column C) worked like a gem, then I found I needed to modify your second and third loops as the cells in columns F & G contain formulas instead of numeric values. Once I had done that, those loops worked beautifully, too. I found I also had to slightly modify your code in the final line of the last loop ("rcell.Value = rcell.Offset(-1).Value & " Combined Average") as my request hadn't been altogether clear. I needed to have the unique Rep Name from column A brought down to the first blank row (which your code does), but then I needed to have the next label placed in column B rather than concatenating the name & "Combined Average" both in column A, so I added "rcell.Offset(, 1).Value = "Combined Average"" which did exactly what I needed.

My final question is this: How do I move columns A:E of each resultant row back to Sheet1 into the blank space that I've already placed beneath each unique Rep Name? Some of the cells (column C) contain formulas rather than numeric values, so I need to take that into consideration when the rows are transferred.

Thanks again for the help, John. It was outstanding! I'm studying your code today to learn more from it so I don't have to ask so many questions! 'Preciate it. If you or anyone can help with this last bit, I'll be grateful.