Apple - Numbers - Split text or reference words in a cell
I have daily orders that I would like to able to enter into a cell that automatically gets split into a table.
Example:
Order# | Method of Delivery | Line number | Account | Reference
Would be entered into cell as:
51698 Driver 3 A2514D K-91
12345 Ship 5 D5215R K-25
Desired Result:
| Order | Method Of Delivery | Line # | Account | Reference |
|---|---|---|---|---|
| 51698 | driver | 3 | A2514D | K-91 |
| 12345 | Ship | 5 | D5215R | K-25 |
Also,
I would like to be able to filter the method of delivery (or at least sort it by Method of Delivery)
Any help is appreciated
iWork for iCloud-OTHER