LVExcel
Board Regular
- Joined
- Nov 23, 2011
- Messages
- 59
- Office Version
- 365
- Platform
- Windows
I received this data (with thousands of records), where Tracking numbers are stored in a single cell and need a row for each tracking number with adjacent cell's data copied to each row.
My problem is that Tracking numbers have no space between them or comas in order to do Text To Column and then Transpose to rows.
Can someone please help me with this.
My problem is that Tracking numbers have no space between them or comas in order to do Text To Column and then Transpose to rows.
Can someone please help me with this.
Tracking Nos | Cartons | Wght | Freight |
5845717537626 5845717538850 5845717539309 5845717537578 | 4 | 33.2 | 65.34 |
4845717973809 4845717970729 4845717976326 4845717976175 4845717977594 4845717979211 | 6 | 76.4 | 155.84 |
3846112383761 3846112385190 3846112387171 | 3 | 47.4 | 62.33 |