Inserting new rows based on columns

[RyanUK]

Hi all,

I'm trying to figure out the best way how to do the following, either through some formula or macro.

I have four colour options and if there is more than one colour column with a value I need it to create a new row underneath, copy down the price and cells etc (and insert "Variant" into the first column).

The upper records are examples of the way the records are currently set and the lower records are the output I need them to be in

Please see the attached image, I hope that will make more sense. I need to do this for around a thousand records.

Many thanks

Ryan

 

[hiker95]

RyanUK,

You are posting a picture. This means that if this was a problem where one needed to use your data, anyone trying to help you would have to enter the data manually. That makes no sense and I doubt that you would get any answer.


What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

If you are not able to give us screenshots, see below in my Signature block: You can upload your workbook to Box Net