Renumbering positions in hierarchy,
Below is a list array.
Always start on level 1.
Positions have to be numbered, increments are 10. Starting with 10.
When there is a change from level 1 to 2, position must start with 10 again.
Same for change from level 2 to 3 and so on.
When go back from level 2 to 1, numbering has to start with increment 10 on the previous position from level 1
Is there a suggestion (I can renumber, when the level changed back it want remmeber the position)
Level|Position|ItemGroup|I
1 | |PCBFLX |401246900|
1 | |CASCER |402984000|
1 | |CASCER |402961200|
1 | |MPCAH |401617802|
2 | |CASCER |400094000|
2 | |CASCER |402961600|
2 | |CASCER |402961000|
2 | |CASCER |402965000|
2 | |CASCER |402965100|
2 | |CASCER |402976900|
2 | |CASCER |402965200|
2 | |DISDIO |400568400|
1 | |CASCER |402961200|
1 | |CASCER |402961200|
2 | |CASCER |402965200|
3 | |CASCER |402965200|
3 | |CASCER |402965200|
1 | |CASCER |402965200|
Result should be:
Level|Position|ItemGroup|I
1 | 10 |PCBFLX |401246900|1 | 20 |CASCER |402984000|1 | 30 |CASCER |402961200|1 | 40 |MPCAH |401617802|2 | 10 |CASCER |400094000|2 | 20 |CASCER |402961600|2 | 30 |CASCER |402961000|2 | 40 |CASCER |402965000|2 | 50 |CASCER |402965100|2 | 60 |CASCER |402976900|2 | 70 |CASCER |402965200|2 | 80 |DISDIO |400568400|1 | 50 |CASCER |402961200|1 | 60 |CASCER |402961200|2 | 10 |CASCER |402965200|2 | 20 |CASCER |402965200|3 | 10 |CASCER |402965200|3 | 20 |CASCER |402965200|1 | 70 |CASCER |402965200|