Categorizing data for multi-level hierarchy

[Lukj]

Hello community,

I am experiencing a problem. I hope that the picture below will make my problem clear.

Basically i want to make a hierarchy with 3 levels. The first/top level contains only the first letter of the ZKSL column with the text from the OMSCHR column. The second level gets the letter with 2 digits, the third level gets the first 6 of the ZKSL level. Getting the first 1, 3 or 6 entries from the ZKSL column was not hard. The problem is that i want the OMSCHR behind it. As you can see every row only has 1 OMSCHR value.  Eventually every row gets 3 columns for the 3 different hierarchy levels with 3 different OMSCHR values. 

  

So the third row will eventually look like this:  

Would be really great if anyone can help me with this!

[DataInsights]

Hello, were you able to resolve this?