Hi I have a dataset where I have to remove everything above name.
| F1 | F2 | F3 |
| LMAO Ltd | Help | |
| Corporation | ||
| Name | Last name | |
| Leo | Messi | |
| Cristiano | Ronaldo | |
| Robert | Lewa |
I have to remove everything above the last name (can't sample tool) It should be dynamic and also remove the null row in the above dataset
Output:
| F1 | F2 | F3 |
| Name | Last name | |
| Leo | Messi | |
| Cristiano | Ronaldo | |
| Robert | Lewa |
