Excel Hierarchy

**aetedford** · 09-24-2019, 03:46 PM

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?

**Pepe Le Mokko** · 09-25-2019, 02:47 AM

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**aetedford** · 09-25-2019, 10:48 AM

Sample File added, as requested above.

**AliGW** · 09-25-2019, 10:57 AM

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)