Hi, I'm wondering if there's a way that I can reorganise the data as below?
The data in Column B separates the different strings using ";"
And we'd like to separate each string of data out onto its own row, with its original Line ID?
Preferably on a separate results sheet, if at all poss
The data in Column B separates the different strings using ";"
And we'd like to separate each string of data out onto its own row, with its original Line ID?
Preferably on a separate results sheet, if at all poss
Line_ID | Data | Results (preferably on a different sheet): | Line_ID | Data_V1 |
---|---|---|---|---|
4 | orange;black;54632 | 4 | orange | |
12 | black;Grey | 4 | black | |
81 | 2222_4;WHITE;red | 4 | 54632 | |
12 | black | |||
12 | Grey | |||
81 | 2222_4 | |||
81 | WHITE | |||
81 | red | |||