Setting Rows to Odd and Even Values


Problem

In manufacturing, sometimes you need to do strange things, like cause certain parts to be interleaved when they run down the line. I recently ran across this problem at work and wanted to share my solution to this problem.

In this example there is a single work order with a quantity of five with the color of red. There is a second work order quantity of 5 color of white. The first part of the problem is breaking out the two work order rows to ten rows because of the quantity. The second problem is interleaving the rows, so