Greetings. I am new to this post but hope that someone can help me. I have a pivot that includes customer unit data and I need to create an average for each row based on the first populated column for each customer. After one month of units appears for the customer, I need to calculate the average going forward, and if there are blanks after that they should be treated as 0 in the average. Below is an example of my description of the pivot.
Jan Feb Mar Apr
Customer #1 1 3 4
Customer #2 1 3
Customer #3 2 2

So, the average for customer 1 would be calculated from column B to Column E, and factor column C as a 0. Customer 2's average would start in column C and go to column E, and factor column E as a 0. Customer #3's average would start in column D to Column E.

I have figured out how to show in the column the first column that is populated, however, I can't figure out how to get this moving average for each row to calculate.
Any help is appreciated!