I've got an Excel list which is 15,162 records.
Its a list of item numbers against which there are equal alternatives.
EG
1234 = 4567
1234 = 891011
1234 - 121314
What i want to do is to keep one record 1234, but then produce mutiple rows eg.
1234 = 4567,891011,121314
Any ideas
Its a list of item numbers against which there are equal alternatives.
EG
1234 = 4567
1234 = 891011
1234 - 121314
What i want to do is to keep one record 1234, but then produce mutiple rows eg.
1234 = 4567,891011,121314
Any ideas