Hi all,
First time posting on here so please let me know if you need any additional info from what I provide.
In short, I am trying to to acheive the following:
Customer ABC, Address 1, Address 2, Address 3, Town, Postcode, Product Code, Description, Qty = 3
The excel file needs to be transformed into:
Customer ABC, Address 1, Address 2, Address 3, Town, Postcode, Product Code, Description, Qty = 1
Customer ABC, Address 1, Address 2, Address 3, Town, Postcode, Product Code, Description, Qty = 1
Customer ABC, Address 1, Address 2, Address 3, Town, Postcode, Product Code, Description, Qty = 1
Here are screen shots of how the file is currently presented:
The highlighted columns are those that need to be payed attention to, for example in Z7 there has been 2 of the same product ordered. This needs to be ammended to 2 lines with the quantity being '1' for each. The rest of the data in the line should be same. Below is an example of how I would like the result to be:
As you can see the line has in effect been copy and pasted, however the quantity has changed to 1 for each line. Just for clarification, this could be the case for any one of the cells within column 'Z', it all depends on whether more than one of the same product has been ordered.
Hopefully this is well undertsood and you guys can help me out! I really appreciate you having a look.
Many thanks
First time posting on here so please let me know if you need any additional info from what I provide.
In short, I am trying to to acheive the following:
Customer ABC, Address 1, Address 2, Address 3, Town, Postcode, Product Code, Description, Qty = 3
The excel file needs to be transformed into:
Customer ABC, Address 1, Address 2, Address 3, Town, Postcode, Product Code, Description, Qty = 1
Customer ABC, Address 1, Address 2, Address 3, Town, Postcode, Product Code, Description, Qty = 1
Customer ABC, Address 1, Address 2, Address 3, Town, Postcode, Product Code, Description, Qty = 1
Here are screen shots of how the file is currently presented:
The highlighted columns are those that need to be payed attention to, for example in Z7 there has been 2 of the same product ordered. This needs to be ammended to 2 lines with the quantity being '1' for each. The rest of the data in the line should be same. Below is an example of how I would like the result to be:
As you can see the line has in effect been copy and pasted, however the quantity has changed to 1 for each line. Just for clarification, this could be the case for any one of the cells within column 'Z', it all depends on whether more than one of the same product has been ordered.
Hopefully this is well undertsood and you guys can help me out! I really appreciate you having a look.
Many thanks