remove everthing above the row based on condition
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Sshasnk
8 - Asteroid
‎10-26-2022
11:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Labels:
- Labels:
- Best Practices
- Common Use Cases
- Datasets
2 REPLIES 2
gautiergodard
13 - Pulsar
‎10-26-2022
12:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binuacs
21 - Polaris
‎10-26-2022
12:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
