I have a column that has around 500 cells and in each cell has one of these 3 values - SW_A, SW_B, and Light
Now I want to create a column that will have the value of the start column in even number cells and the value of the stop column in odd number cells if the component is LIGHT.
Like this:
Is there anyway to automate this with a formula?
Thank you
Now I want to create a column that will have the value of the start column in even number cells and the value of the stop column in odd number cells if the component is LIGHT.
Like this:
Is there anyway to automate this with a formula?
Thank you