Excel: URGENT - Duplication Process


I need help with creating the following operation:

Finished Good 1 0 A
Finished Good 1 1 B
... ... ...
Finished Good 1 20 U
Finished Good 2 0 A
Finished Good 2 1 B
... ... ...
Finished Good 2 20 U
Finished Good 30,888 0 A
Finished Good 30,888 1 B
... ... ...
Finished Good 30,888 20 U
Column A is duplicated and then changed to the next in order. Column B & C remain the same. Column B stays 1-20. Column C is the same for the 20 rows, but is not actual "A", "B"..."U".


This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of December 12, 2014.


For more resources for Microsoft Excel