What supplier or reference site are you downloading from and what sales channel are you trying to upload to?
Are you looking for a referral to a company or product which will do the conversion or are you looking for someone to write a conversion program? If the latter is the case, I'll have to opt out because I'm not really interested in doing it for the question value presented.
Okay, I'll opt out then because having done what you're doing... I know what's involved and don't really have the time to write a custom program for this right now.
Can you clearly describe which columns in format 1 should become what in format 2?
Extra columns in format 1 - discard? (i.e. those w/o destination in format 2)
Extra columns in format 2 - leave blank? (i.e. those w/o source in format 1)
I'm sorry the csv format doesn't preserve things like highlighting; and the file looks pretty garbled as it is. Can you just attach the xls or xlsx file (what version Excel?)
Thanks, ***** ***** can't make sense of that though. A1 and C1 each look like one long string of column headers, comma separated text. If those represent format 1 and 2, respectively, I still don't know "what" means "what" going from 1 to 2.
Most of the file looks like the result of a copy/paste of a table from a web browser page, I don't know what to do with that.
These look pretty much like the initial files you sent. I can't interpret their contents to guess at what you're after.
Have you actually opened these files in Excel yourself?
I'm going to opt out and let someone else have a crack at this. Maybe it'll be more obvious to them... Sorry I couldn't help you out.