Phoenix - Your AI AssistantData Amalgamation
- Posted:
- Proposals: 13
- Remote
- #1518170
- Awarded
Kornos 
Description
Experience Level: Entry
We require assistance in consolidating data on a spreadsheet which outlines the usage history of a raft of products. We need someone to go through and identify the volume of products purchased, removing reference to sizing. Additionally, the most recent order date must be left for reference.
"All the like codes regardless of size should be amalgamated on one line showing the total number purchased across all sizes in column E and the description in column D altered to show the size range along with the size removed in column C. For example B01-7701 would show the code in column C as B01-7701 and would read ‘Black ski boot S1P size 07 – 14 – Pair’ in column D and would show the total number purchased (74) in column E."
I can provide the spreadsheet for reference upon request.
"All the like codes regardless of size should be amalgamated on one line showing the total number purchased across all sizes in column E and the description in column D altered to show the size range along with the size removed in column C. For example B01-7701 would show the code in column C as B01-7701 and would read ‘Black ski boot S1P size 07 – 14 – Pair’ in column D and would show the total number purchased (74) in column E."
I can provide the spreadsheet for reference upon request.
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Emily,
In order to avoid cancelling and re-submitting my proposal after your having attached the spreadsheet in concern, I would simply like to let you know that it still holds for the same quoted price (for a macro to do most of the work).
Regards,
Demetrios -
Hi Emily
Is it possible that you could provide a sample of the existing data?
Kind regards
Claire