Create a multi-level table with a drop-down list

Sergey
Employer

[no-member:pro]Sergey[/no-member:pro]Sergey

1 projects
Closed
Project parameters
Type of cooperationOne-time project
Prepaymentwithout prepayment
Payment methodsBank transfer, Electronic money
Acceptance of requestsclosed
Project description
Remote work for a specialist in creating tables. You need to create a multi-level table with a drop-down list.
I mean. When you fill in the first column, you should disclose a list of what you can enter. When filling in the second column, a list of only what corresponds to the one entered in the first one is disclosed.
It should also be able to supplement or change the nomenclature on another sheet and sort it alphabetically.
Project author: Sergey