What I would like is a tool to extract particular columns and merge customer address (in shipable format) from Ebay csv sales history file. I have sample files for both. The final file can be in excel or any format that be user friendly.
# There are many columns that come as default in ebay sales history file
# I need a selected few columns only ([url removed, login to view]) and remaining to be deleted
# Customer address from ebay is in format
Buyer Fullname|Buyer Address 1|Buyer Address 2|Buyer City|Buyer State|Buyer Zip|Buyer Country
# We want the format to be when exported
Buyer Address 1
Buyer Address 2
Buyer City Buyer State Buyer Zip
Note: If Buyer Address 2 is empty then it should not be included.
I will take suggestions on the procedure of import. If you need more clarification then email me.