Hi there,
I need to copy a sheet with rows containing a value in the first six columns to another sheet iin a way that for each row the first 3 cols and the 4th col is copied to a new row, followed by a row containing the first 3 cols and the 5th col, and next a row with the first 3 cols and the 6th col.
In other words:

from (sheet 1)
r1 a b c d e f
r2 a b d e f h
r3 b d e f g h

to (new sheet)
r1 a b c d
r2 a b c e
r3 a b c f
r4 a b d e
r5 a b d f
r6 a b d h
and so on...

Thks for yr help !
Eric