@Gopigk
Member
Hi all,
I have data in excel, where I am receiving multiple Job/Lot numbers in one cell against one Invoice number. But I need that data like each job/Lot-wise in separate rows. It is a repeated task and I am doing every time like separating them into columns and transpose them into rows. As I need to work on huge data, this is a very tedious task for me to complete. Herewith I attached a sample excel file for ready reference. There are 2 sheets, in sheet 1 original raw data as received and in sheet 2 sample format as I required.
Request to verify and help me in this
I have data in excel, where I am receiving multiple Job/Lot numbers in one cell against one Invoice number. But I need that data like each job/Lot-wise in separate rows. It is a repeated task and I am doing every time like separating them into columns and transpose them into rows. As I need to work on huge data, this is a very tedious task for me to complete. Herewith I attached a sample excel file for ready reference. There are 2 sheets, in sheet 1 original raw data as received and in sheet 2 sample format as I required.
Request to verify and help me in this