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 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago