SteveBates
New Member
- Joined
- Jun 15, 2015
- Messages
- 1
I receive external data every day. However, the originator adds multiple values to a single cell seperated by a comma rather than tabulating the data as below:
<tbody>
</tbody>
Is there a simple way to seperate the individual order numbers into individual vertical cells and copy the Unique ID to each new row?
Unique ID | Order 1 | Order 2 | Order 2 | Oder 3 |
128168 | IBHG8CNL | IBHPMLNJ, IBHTALPP | IBFPEAEE | IBFPEAEE |
94714 | IBGGCJNJ, IBHFE8JN, IBJ0EGFX | IBHRRGFP | IBFP8KPU, IBKEPEJJ, IBKERVGZ | IBFP8KPU, IBKEPEJJ, IBKERVGZ |
116132 | IBFU9LUS, IBFUAAMM, IBFUAWLJ, IBFUCCFR, IBGL04AV | IBGJ1CMN, IBGMHPVS | IBFR9VUK | IBFR9VUK |
116969 | IBJ19FHK | IBJ9KHMJ | IBHPAHGV | IBHPAHGV |
<tbody>
</tbody>
Is there a simple way to seperate the individual order numbers into individual vertical cells and copy the Unique ID to each new row?