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.
@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!!
Do you know if there is a way to do this without using a macro?