I currently have a list like the following image with 3 different layers in different columns, and they are dependent. I am trying to make a 3-layer drop-down menu using this data.
In order to make drop-down menu, I first create the following layout of table for first and second drop-down menus:
Then I append these 2 values together then create the following layout of table for third drop-down menu:
As list in image 1 will keep on growing or being modified, I was hoping to use image 1 as a base with Query Editor to generate image 2 and image 3. However, I cannot succeed...
Is there an easier way of making this 3-lay drop-down menu using dynamic 3-column excel?
Thank you so much for your help and time.