remove everthing above the row based on condition

Question

Hi I have a dataset where I have to remove everything above name.

F1F2F3LMAO Ltd HelpCorporation     Name Last name   Leo Messi   Cristiano RonaldoRobert 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:

F1F2F3Name Last nameLeo MessiCristiano RonaldoRobert Lewa

binu_acs · Answer

@Sshasnk One way of doing this

remove_fiels_1026.yxmd

gautiergodard · Answer

hey @Sshasnk

Please see attached for one way to do this!

sort.yxmd