Need to delete rows based on calculation and values in other rows

[Infrecon]

I have the following test table and I would like to have the following result, see below. 

RecordID	Name	Value1
7530	1
7530	2
7530	3	Test_Text1
7530	4
5640	1
5640	2
5640	3	Test_Text2
5640	4
5640	5

RecordID	Name	Value1
7530	1
7530	2
7530	3	Test_Text1
5640	1
5640	2
5640	3	Test_Text2

I have created or used a transpose for a dynamic hierarchy.

But now I want to delete the rows that are larger in name than their name, where there is a value in it.

[Felipe_Ribeir0]

Hi @Infrecon 

Here is one way to get the expected output.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[Infrecon]

Hi @Felipe_Ribeir0 

unfortunately, not practicable, as the original database contains 14000 entries :)

Or let's talk from the beginning. Maybe there is a simpler version than mine.

The following initial situation:

CHOP_Code	Indent_Level
C0	1
Z00	2
Z0312	3
Z03124	5
Z2103	4
Z021	3
C1	1
Z23123	5
Z23	2

CHOP_Code	Level 1	Level 2	Level 3	Level 4	Level 5
C0	C0
Z00	C0	Z00
Z0312	C0	Z00		Z0312
Z03124	C0	Z00		Z0312	Z03124
Z2103	C0	Z00		Z2103
Z021	C0	Z00	Z021
C1	C1
Z23123	C1				Z23123
Z23	C1	Z23

[Felipe_Ribeir0]

Hi @Infrecon 

Understood, for this amount of rows it is not a good idea to use the append. Try this one, i understand that this one has a much better performance.

[Felipe_Ribeir0]

Another and more performatic option to the original problem. 

[Felipe_Ribeir0]

Hi @Infrecon 

It worked?