Consolidate similiar data in spreadsheet, opens in excel
$30-250 USD
进行中
已发布大约 11 年前
$30-250 USD
货到付款
Consolidate Data with the same PRODUCT ID.
Perform a sum of the QTY Column for those Products ID that are the same.
The SKU Column is not required to be present in the new file nor is the ITEM/NAME Column.
Essentially all I need is a file with the ITEM/NAME the PRODUCT ID and a NEW Total QTY
The File has roughly 65k Rows of data.
Current Format of File.
ITEM/NAME \ SKU \ QTY \ PRODUCT ID
--------------------------------------\---------------------------\---------------\----------------------------
Row22 201 Organic Baby Purees 01-050305 8 1440528993
Row28 201 Organic Baby Purees 01-050305 2 1440528993
Row56 201 Organic Baby Purees SKU050305 7 1440528993
Needed Format Example.
ITEM/NAME \ SKU \ QTY \ PRODUCT ID
--------------------------------------\---------------------------\---------------\----------------------------
Row1 201 Organic Baby Purees Not Needed 17 1440528993
Fair easy Job for me. So quoted accordingly. will come up with sample excel file (with the data provided in description) the way you require. 5 minutes from the time I placed my bid Please. Then we can discuss further through your inbox.
Greetings,
I have many years of Visual Basic (including VBA macros) development experience. I am available to begin work on your project immediately.
Thank you for considering my bid,
Matt