Job Posted: 02.09.2021 14:13:07
From the excel file "Order_line_items", find each individual shop_id and copy all the cells from it and paste it into a new sheet/file. Example: The first shop_id in the excel file order_line_items is: fa46cdba-8900-4da9-aa85-7c88b1e7dedb. I copy all the cells in this row into a new file. I then og back to the original file and press ctrl+b to search for all instances of shop_id fa46cdba-8900-4da9-aa85-7c88b1e7dedb. Then I copy all the rows with this shop_id and paste it to the other file. The file you paste into should be given the name of the shop_id. Do this with each unique shop_id.