Range of date filling missing dates

diegonogueira

Hi, I'm looking for a way to fill missing or blank values with the last value. For instance:

Month | total 1| total 2
Jan | 10 | 20
Fev | 12 | 21
Jun | | 21
Jul | 14 |

1 - there's a way to auto create a new lines on missing months with the last month totals? On March and April?
2 - There is a way to auto fill the Jun total 1 with the last value Fev total?

Thanks,
Diego

fearednerd

There is a fnAddData function that gives you the ability to add a new row of data. Not sure how to make it so that it will detect missing months. You probably have to code that yourself.