I have some data found here: https://1drv.ms/x/s!AktAOe8JUNECiKkS...X5GdQ?e=eYGYBa

Column A is the PARENT with 00000000 the TOP value.

Looking at the data in column B, we see 00000000 has many 2nd level values. Looking at the first 2nd level, 00000004, we then look that up in COLUMN A. No more values, so that one ends.

00000000 -> 00000004

The next one in Column B is 00000412. Looking that up in COLUMN A, we see it has 52 2nd level values. Then looking up those values, we get 3rd level and so on.

We start seeing how it builds.

LEVEL 1 LEVEL 2 LEVEL 3 LEVEL 4 LEVEL 5 LEVEL 6 LEVEL 7
00000000 00000004
00000000 00000412 00000026 00014616
00000000 00000412 00000034 00000029 00000009 00003415
00000000 00000412 00000034 00000029 00000012
00000000 00000412 00000034 00000029 00004491 00000010 00003416
00000000 00000412 00000034 00000029 00004491 00000010 00014419
00000000 00000412 00000034 00000029 00004491 00000011
00000000 00000412 00000034 00000031
00000000 00000412 00000034 00013412
00000000 00000412 00000037 00000024
00000000 00000412 00000037 00000025
00000000 00000412 00000037 00000028 00007142 00014412
00000000 00000412 00000037 00000033 00000012
00000000 00000412 00000037 00000033 00000014 00000015
00000000 00000412 00000037 00000033 00000020
00000000 00000412 00000037 00000035 00000036
00000000 00000412 00000037 00000035 00014412
00000000 00000412 00000037 00003368
00000000 00000412 00000037 00004615
00000000 00000412 00000037 00004732
00000000 00000412 00000037 00013604
00000000 00000412 00000074 …
00000000 00000412 00000154 …
00000000 00000412 00000214 …

How can I automate this? Is it possible? Should it be done in something else, such as PowerBI?