Retrieve data from table.

[Michnia25]

Hi,

I have a problem with a multilevel parent-child relationship in my table. The table contains two columns: "parent" and "child." The "parent" column has hundreds of different codes, and each code has several child codes contained within it.

For some items, the child codes become parents as they also include other child codes, and so on.

I've been trying to find a way to achieve the following outcome, but after two days of trying, I gave up. Can someone please help me with this?

 

[Herakles]

Hi,

I have a problem with a multilevel parent-child relationship in my table. The table contains two columns: "parent" and "child." The "parent" column has hundreds of different codes, and each code has several child codes contained within it.

For some items, the child codes become parents as they also include other child codes, and so on.

I've been trying to find a way to achieve the following outcome, but after two days of trying, I gave up. Can someone please help me with this?

View attachment 99248

I can deduce from your Data table what the relationships are but what do you want to do with this data?

Can you please update your profile to indicate what version of Excel you are using?

I assume that these are not the actual codes that you will be using but just used here to demonstrate the idea to us.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.