PnL hierarchy field with indentations

[pamaxeed]

Hi guys,

can somebody help me with this problem.

I have a single field which reflects the account hierarchy with a lof of indentations like that:

I would like to transform the indent hierarchy in a flat hierarchy like (we have L1-L12). Is there a way to achieve the following output assuming that the indent Levels have always the same paddings?

Key	Level 1	Level 2	Level 3	Level 4	Level 5	Level 6	Level 7	Level 8	Level 9	Level 10	Level 11	Level 12
	NetInc
	NetInc	OpProf
	NetInc	OpProf	OpResult
	NetInc	OpProf	OpResult	OpRev	NetIntIncProv
	NetInc	OpProf	OpResult	OpRev	NetIntIncProv	NetIntInc
	NetInc	OpProf	OpResult	OpRev	NetIntIncProv	NetIntInc	LB_DB
	NetInc	OpProf	OpResult	OpRev	NetIntIncProv	NetIntInc	LB_DB	LB
	NetInc	OpProf	OpResult	OpRev	NetIntIncProv	NetIntInc	LB_DB	LB	5110R
	NetInc	OpProf	OpResult	OpRev	NetIntIncProv	NetIntInc	LB_DB	LB	5115R

Attached you can find some dummy data of the delivered data.

Thanks and regards,

Patric