My worksheet has following two tables
Table 1 : Category
category_id
main_category
sub_category
Table 2 : Vendors
vendor_id
sub_category
venodor_name
Table 1 : Category Sample data as follows
1,ENTERTAINMENT,OTT
2,SHOPPING,SHOPPING_APPS
Table 2 : Vendor List sample data as follows
How to make a depended dropdown using two sheets / two tables in a single view.
ie when user select category dropdown, it shows dependent sub category when user select a sub category it further shows vendor dependent dropdown.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |