Help reformatting bad data extract

[markpgates]

All,

Need help reformatting a data dump from my work system. Unfortunately when trying to get a dump of orders by day, with customer name, product and quantity, it puts the customer name in the same column!! I need to download 3 months worth of orders, please help!

Cheers

PS example attached, want customer name in seperate column!
PPS how do I attach an example file?!

 

[sandy666]

use OneDrive, GoogleDrive or any similar, share excel file with representative source example and expected result, post link here