Could anyone help me out with a script to fill cells from columns of data
I am not 100% sure how to describe it.
Basically I need to fill column C, D, and E, by series fill down based on on trend. Then column F and G I need to fill by copying the last known value down.
For example....
Initial table
<tbody>
</tbody>
Table after script is ran
<tbody>
</tbody>
I am not 100% sure how to describe it.
Basically I need to fill column C, D, and E, by series fill down based on on trend. Then column F and G I need to fill by copying the last known value down.
For example....
Initial table
A | B | C | D | E | F | G | |
1 | PHMD | API | MD | INC | AZM | DLS | MDLS |
2 | 7803 | 1234 | 7803 | 13 | 345 | 10 | 12 |
3 | 7804 | 1234 | |||||
4 | 7805 | 1234 | |||||
5 | 7806 | 1234 | 7806 | 34 | 350 | 7 | 8 |
6 | 7807 | 1234 | |||||
7 | 7808 | 1234 | 7808 | 60 | 355 | 11 | 13 |
<tbody>
</tbody>
Table after script is ran
A | B | C | D | E | F | G | |
1 | PHMD | API | MD | INC | AZM | DLS | MDLS |
2 | 7803 | 1234 | 7803 | 13 | 345 | 10 | 12 |
3 | 7804 | 1234 | 7804 | 20 | 346.66 | 10 | 12 |
4 | 7805 | 1234 | 7805 | 27 | 348.33 | 10 | 12 |
5 | 7806 | 1234 | 7806 | 34 | 350 | 7 | 8 |
6 | 7807 | 1234 | 7807 | 47 | 352.5 | 7 | 8 |
7 | 7808 | 1234 | 7808 | 60 | 355 | 11 | 13 |
<tbody>
</tbody>
Last edited: