I have a column with the numbers 1-200 decending in each cell. In the next column I wish to put the letter R within multiple cells in the same column.
I would like every time I put the letter R in a cell to copy all numbers down over beside it and then paste in the next line below. i.e I could have each number cell 1,2,3,4,4,5,6,7,8 if I put the R next to the next column next to the number four.
Any script that would do this automatically would be much appreciated.