Dynamic 3-layer dropdown menus

Copper Contributor

Hello everyone,

 

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.

3-layer Columns.jpg

 

In order to make drop-down menu, I first create the following layout of table for first and second drop-down menus:

Dropdown1.jpg

 

Then I append these 2 values together then create the following layout of table for third drop-down menu:

Dropdown2.jpg

 

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.

0 Replies