Hi, I have a requirement where my data has a column with same item and another column with different widths. say as table below. Now In another cell when 'BAL' is selected, I want the adjacent cell which has the title Width to show a drop down list consisting of all the valid values of 'BAL' i.e., 6, 9, 15,18. How can this be done. kindly help
| Item | Width |
|---|---|
| BAL | 6 |
| BAL | 9 |
| BAL | 15 |
| BAL | 18 |
| BAR | 6 |
| BAR | 9 |
