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 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago