I have a spreadsheet that currently contains numbers and is separated by "XXXXX". I would like to add the number in the previous row to the X's and do the same operation for the whole column. Any thoughts? Here is a sample of my current data:
A 1 | B 1188 | C |
1 | 1189 | |
1 | 1190 | |
XXXXX | XXXXX | XXXXX |
2 | 1191 | ** |
2 | 1192 | |
2 | 1193 | |
2 | 1194 |