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 |
Solved! Go to Solution.
Hi @TiffanyH12 I mocked up a workflow that produces the output you describe. Let me know what you think?
This did exactly what I needed, thank you!