I have the below columns and I want to find the last occurrence of Yard Zone for each of the specific identifiers and put "Yard Zone" in another column when
it finds the last one.
it finds the last one.
TF-55143843 | Yard Zone |
TF-55143843 | Yard Zone |
TF-55143843 | Yard Zone |
TF-55143843 | Yard Zone |
TF-55143843 | Yard Zone |
TF-55143843 | |
TF-55143843 | |
TF-55143850 | |
TF-55143850 | |
TF-55143851 | |
TF-55143851 | |
TF-55143852 | |
TF-55143852 | |
TF-55143853 | |
TF-55143853 | |
TF-55143854 | |
TF-55143854 | |
TF-55143854 | |
TF-55143857 | Yard Zone |
TF-55143860 | Yard Zone |
TF-55143860 | Yard Zone |
TF-55143860 | |
TF-55143860 | |
TF-55143860 | |
TF-55143860 | Yard Zone |
TF-55143860 | |
TF-55143861 | |
TF-55143861 | Yard Zone |