Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question

migrated from Sep 6 '12 at 22:52

This question came from our site for professional and enthusiast programmers.

A question like this is probably more appropriate for

But I will show you one of the many ways you could do this:

image1 image2 image3 image4 image5

Of course you could write a macro to do this, you could use functions to do this - this is a simple task and has many different solutions.

But this method is an example of very basic excel usage and only requires a knowledge of sort and autofill and copy/paste. Good Luck.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.