Creating a heirarchy in a hierarchy using IDs based on range of values between in it.

[sumeet_deokar]

We have data for which hierarchy is defined within it and we need to categorised the data based on the range.

So for example,
100000-299999 is the main hierarchy in it we have 120000-129999, furthermore we have 120200-120299 as the inner category.
100000

           120000

                       120200

                            .

                            .

                        120299

           129999

299999

This is how roughly we can describe the structure.

So, we want a column that defines the structure, If we are having 120200-120299 as A, so 120000-129999 should be A(A) and further ahead 100000-299999 should be A(A(A))). Something to that effect,Yellow hiughlighted should be categorised under L&B while the Pink highlighted should be under P&M and so on

[sumeet_deokar]

Based on the numbers and colours highlighted I want to create a column of category that says which category these numbers belong to depending on the levels.

[lbendlin]

Your color assignments do not follow any discernable logic.  You will need to use a manual mapping table.

[lbendlin]

ok. what is your question?  What have you tried and where are you stuck?