Good day, how to make all cells to left blank if a value is entered in a
cell, therefore i want bto select from dropdown asset pipeline and all left
cell row 2 be unable to be populated

a b c d e
Proj Asset Phase Wk Package Component
1 Rock
2 Pipeline
3 1
4 procure
5 Rig
6 2
3
b 2
3
4