need to parse out a field with multiple items in field
I have a download from our ERP system. It contains 11 fields. the 11th field, is a note/memo field that can contain up to XX number of unique order identifiers. In this field each unique identifier is separated by a space.
I need to parse each unique identifier into it's own ROW. I have attached a file as an example. Any suggestions?
Attachment | Size |
---|---|
file example for excel question on parsing out a multiple value field.xlsx | 11.21 KB |
Recent comments
5 years 6 weeks ago
5 years 44 weeks ago
6 years 4 weeks ago
6 years 7 weeks ago
6 years 8 weeks ago
6 years 13 weeks ago
6 years 21 weeks ago
6 years 22 weeks ago
6 years 22 weeks ago
6 years 22 weeks ago