I need an Excel expert to adjust my excel spreadsheet. Currently, i am handling it manually. I know there could be some smarter way to save my time. See attachments and my problem descriptions below:
1, Attached you can find a screenshot of the orders I exported from our E-commerce site. I need to upload it to our courier system for shipping processing;
2, According to the rule of the courier system: each parcel should occupy 1 single row only;
3, In the excel I exported, some of the orders have more than 1 or even 2 rows as they purchased 2 or 3 different items;
4, The E-commerce system separates the rows for different items for identification, even they are for the same order.
5, Then we have to manually combine the rows under the same order number, merge the column of products for each order. And it takes too much time;
6, When merging the rows, the items should NOT be added to the same cell of the first product. It should be moved to a cell after the first item.
7, Is there any smarter way to do the step 5 by programming or something?
December 23, 2017
I am willing to pay higher rates for the most experienced freelancers