Excel Hierarchy

aetedford

New Member
Joined
Mar 26, 2018
Messages
2
I have some data found here: https://1drv.ms/x/s!AktAOe8JUNECiKkS30iC2jH4jX5GdQ?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 1LEVEL 2LEVEL 3LEVEL 4LEVEL 5LEVEL 6LEVEL 7
0000000000000004
00000000000004120000002600014616
000000000000041200000034000000290000000900003415
0000000000000412000000340000002900000012
00000000000004120000003400000029000044910000001000003416
00000000000004120000003400000029000044910000001000014419
000000000000041200000034000000290000449100000011
00000000000004120000003400000031
00000000000004120000003400013412
00000000000004120000003700000024
00000000000004120000003700000025
000000000000041200000037000000280000714200014412
0000000000000412000000370000003300000012
000000000000041200000037000000330000001400000015
0000000000000412000000370000003300000020
0000000000000412000000370000003500000036
0000000000000412000000370000003500014412
00000000000004120000003700003368
00000000000004120000003700004615
00000000000004120000003700004732
00000000000004120000003700013604
000000000000041200000074
000000000000041200000154
000000000000041200000214

<tbody>
</tbody>

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

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Watch MrExcel Video

Forum statistics

Threads
1,100,138
Messages
5,472,743
Members
406,835
Latest member
steve43040

This Week's Hot Topics

Top