Hi All,
Is anyone able to help me with an odd excel question.
I need to split rows into new rows with qty 1.
Eg
Columns Stock Code, QTY, BIN
Row AB 10 AA-AA-AA
I need them to come out as:
AB 1 AA-AA-AA
AB 1 AA-AA-AA
AB 1 AA-AA-AA
AB 1 AA-AA-AA
AB 1...