Dynamic Hierarchy based on multiple columns selection from drop down lists

Hello all,

Need some help to create a dynamic hierarchy by selecting the column names from multiple lists, this will also represent the order in the hierarchy.
Table format is shown below.
Basically it has 6 category columns (c1 to c6) and some values columns (num1 and 2)
What I need is to create 3 dropdown menus and select the respective columns (egg. c1, c4, c2 / c6, c3, c4 ) and filter a respective bar chart or table or other visualization.
Another issue that I have is that after selecting a value from the first dropdown that value should not be present in the second nor third dropdown and so on.

Thank you