I have a spreadsheet full of customer details where the customer may have had one or two products. Product1 is indicated in column U, Product2 in column V.
If the customer has purchased both products I need to duplicate the row then leave the Product1 code as is and set Product2 to NO in the first row, and in the second row set Product1 to NO and leave the Product2 code as is.
The spreadsheet can have 100's of rows - can anyone help me please?
Thank you