Here is the raw data:
ItemNum | Description | Available | MinQty | Case Size | UPC |
ML1213PK | Princess, Frozen & My Little Pony 24pk Nails on Clamshell | 11571 | 12 | 16" x 15" x 9" | 719565377396, 719565356193, 719565356216 |
Final output should look like this:
ItemNum | Description | Available | MinQty | Case Size | UPC |
ML1213PK | Princess, Frozen & My Little Pony 24pk Nails on Clamshell | 11571 | 12 | 16" x 15" x 9" | 719565377396 |
ML1213PK | Princess, Frozen & My Little Pony 24pk Nails on Clamshell | 11571 | 12 | 16" x 15" x 9" | 719565356193 |
ML1213PK | Princess, Frozen & My Little Pony 24pk Nails on Clamshell | 11571 | 12 | 16" x 15" x 9" | 719565356216 |
Solved! Go to Solution.
@Onemajor You can use text to column tool
I have never used this tool as split to rows. Thank you @MilindG for you help.