Loop Through Data Columns

[ashleyinman]

I have a data set like this.

I need a way to be able to allow the user when they select an overall "Parent" it will show all the children/grand/great grant, etc. in new columns. Something like this.

[flying008]

Hi, @ashleyinman 

This is a good question, like BOM link!

[grazitti_sapna]

@ashleyinman , here is my solution to your problem. I have used an iterative macro for this. Please let me know if it was helpful.

Thanks!!

[ashleyinman]

Do you know if there is a way to do this without using a macro?