Hi There,
Is it possible to duplicate records if following condition is met:
I've got a column which is called defects, and each record in my master data may contain none or multiple defects in defect cell.
Each defect is separated by comma for example: Spoilage,Greening
In above example there are 2 defects in a single record so what I'd like to do is to duplicate this record and somehow put one of those defects so that each record so that each record will have it's own defect.
Record 1 - Spoilage
Record 2 - exact same info + Greening instead of Spoilage
Amount of new records to be created will be based on number of defects found in defect cell.
Is this even possible in excel?
Thanks