MS Excel Expert needed
Budget: $10 – $30 USD
We have a requirement to produce weekly reports based on products and quantities sold from an online shop.
I can export all orders broken down by product SKU and I want to be able to then paste that data into a spreadsheet template which will then automatically group by product and sum all the quantities per group.
I have attached a sample spreadsheet for reference. Product SKU is the field to sort by but needs to display the Product Name as well, plus of course the total number of that item sold within the spreadsheet data.
I believe this is something that groups can achieve, but my knowledge is limited in this area.
Maximum spend on producing this spreadsheet template is $30 and we would like it done as soon as possible please so that we can test it out with other data.
Many thanks for looking.
I can export all orders broken down by product SKU and I want to be able to then paste that data into a spreadsheet template which will then automatically group by product and sum all the quantities per group.
I have attached a sample spreadsheet for reference. Product SKU is the field to sort by but needs to display the Product Name as well, plus of course the total number of that item sold within the spreadsheet data.
I believe this is something that groups can achieve, but my knowledge is limited in this area.
Maximum spend on producing this spreadsheet template is $30 and we would like it done as soon as possible please so that we can test it out with other data.
Many thanks for looking.