Always have a maximum of 10 values, with the last value being in B1 and the one in A1 disappearing

I will use a script to copy the data from Column C to Column A, always adding 1 value that is in B1 and remove the A1 value

If I do it this way, there will always be 11 values:

If I do it this way the value of B1 will never appear:

If I do it this way when there are less than 10 values in Column A it will never go from row 7 and add up to row 10:

If I do it this way there will be lines with no values between the data and this cannot happen:

How I wish it were!  

If there are less than 10 values in Column A, look like this:

If there are 10 values in Column A, look like this:

https://stackoverflow.com/questions/66147270/always-have-a-maximum-of-10-values-with-the-last-value-being-in-b1-and-the-one February 11, 2021 at 08:47AM