Home

Dynamic 3-layer dropdown menus

%3CLINGO-SUB%20id%3D%22lingo-sub-873829%22%20slang%3D%22en-US%22%3EDynamic%203-layer%20dropdown%20menus%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-873829%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20currently%20have%20a%20list%20like%20the%20following%20image%20with%203%20different%20layers%20in%20different%20columns%2C%20and%20they%20are%20dependent.%26nbsp%3B%20I%20am%20trying%20to%20make%20a%203-layer%20drop-down%20menu%20using%20this%20data.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20272px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133421i33A32CB874589D93%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%223-layer%20Columns.jpg%22%20title%3D%223-layer%20Columns.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20order%20to%20make%20drop-down%20menu%2C%20I%20first%20create%20the%20following%20layout%20of%20table%20for%20first%20and%20second%20drop-down%20menus%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133419i61E1F69F8BD30369%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Dropdown1.jpg%22%20title%3D%22Dropdown1.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20I%20append%20these%202%20values%20together%20then%20create%20the%20following%20layout%20of%20table%20for%20third%20drop-down%20menu%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133420iD556AB6E707F5F41%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Dropdown2.jpg%22%20title%3D%22Dropdown2.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20list%20in%20image%201%20will%20keep%20on%20growing%20or%20being%20modified%2C%20I%20was%20hoping%20to%20use%20image%201%20as%20a%20base%20with%20Query%20Editor%20to%20generate%20image%202%20and%20image%203.%26nbsp%3B%20However%2C%20I%20cannot%20succeed...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20an%20easier%20way%20of%20making%20this%203-lay%20drop-down%20menu%20using%20dynamic%203-column%20excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%20for%20your%20help%20and%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-873829%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Query%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Primolee
Occasional Visitor

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies