I have a long list of rows in excel. some with a qty of 1 and some with qty higher than one. For the rows where i have a qty higher than one i would like to duplicate the row so that the qty matches the number of those rows.

Snap4.gif