Hi,
Thanks in advance.
I would like your help as whenever my Id is changing I need to add a row with having a value of the previous row **just in the access column I need Name Value.
I/p
Name | Id | Access |
Franklyn | 1850 | Nel |
Franklyn | 1850 | Stul |
Grey | 3434 | Hik |
Grey | 3434 | Phill |
Maj | 1063 | Kroll |
Maj | 1063 | Otaki |
Expected O/p
Name | Id | Access |
Franklyn | 1850 | Nel |
Franklyn | 1850 | Stul |
Franklyn | 1850 | Franklyn |
Grey | 3434 | Hik |
Grey | 3434 | Hof |
Grey | 3434 | Grey |
Maj | 1063 | Kroll |
Maj | 1063 | Otaki |
Maj | 1063 | Maj |
Thanks 🙂
Solved! Go to Solution.
Here's one approach:
EDIT: Not as clean as solutions provided by others... 🙂
Here's one way to accomplish the task:
Workflow attached.