Shiva,

If I interpret your requirements properly try the following:

Assuming your data starts in row 2 of sheet 1, and you want to append
the data starting in row 2 of sheet2. (See below if you want to start
in different rows).

Enter in sheet 2:

Col A: =OFFSET(Sheet1!A$2:A$2,INT((ROW()-ROW(Sheet2!$2:$2))/3),0) and
drag/copy it to col B

Col C:
=OFFSET(Sheet1!C$2:C$2,INT((ROW()-ROW(Sheet2!$2:$2))/3),MOD(ROW(),3)*2)
and drag/copy to col D

Col E: =MOD(ROW(),3)+1 (gives you number of the product suffix from
each row in sheet 1)

If your data in sheet 1 starts in other than row 2, change all the
references to Sheet1!..$2:$2 to $N:$N, where N is the number of the row
in which the data starts.

Similarly, if you want to append in sheet 2 starting at a different
row, change the references to Sheet2!ROW($2:$2) to the other row.