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
7 years 25 weeks ago
8 years 10 weeks ago
8 years 22 weeks ago
8 years 25 weeks ago
8 years 26 weeks ago
8 years 32 weeks ago
8 years 40 weeks ago
8 years 40 weeks ago
8 years 40 weeks ago
8 years 40 weeks ago