I want to be able to fill the third column based on what's showing before it.
There are more fields besides what's shown here. And the number of blanks in between vary. It can have 3 spaces to fill or none.
this is what I have:
Company | F1 | AM0001 |
| Company | F2 | |
| Company | F3 | |
| Company | F4 | |
| Company | F5 | 1 |
| Company | F6 | |
| Company | F7 | |
| Company | F8 | 70 |
| Company | F9 | |
What I want:
Company | F1 | AM0001 |
| Company | F2 | AM0001 |
| Company | F3 | AM0001 |
| Company | F4 | AM0001 |
| Company | F5 | 1 |
| Company | F6 | 1 |
| Company | F7 | 1 |
| Company | F8 | 70 |
| Company | F9 | 70 |
