Hello there,

I've encountered a process as to which I need to sort and arrange things using an excel document to make a program for a machine.

Unfortunately, the way I do it is long winded and slow, I was wondering if there is another way to do it.

The way I do it is spread the numbers out in column D by inserting new rows, and typing all the numbers which takes a long time, in a column, like the example at the bottom of this screenshot.

Then I highlight and drag the other cells so that the circuit ref matches the PN's involved.

Problem.png

Any help would be appreciated, thanks.