I can't seem to sort the excel datasheet in the right way. It needs to be in a particular way so the products can be merged while uploading. In the screenshot, I show you how it is now and how it needs to be. There are around 65k rows, sorting one by one isn't an option. I also provide a sample file with few products inside. The SKU always stays above the parent_sku. It works as follow: Parent product (SKU) is being imported and the variations (parent_sku) of the parent product follow.
U can download the files from the following link: http://s000.tinyupload.com/index.php...10256564919153
https://www.mrexcel.com/forum/excel-questions/1090811-sorting-excel-datasheet.html</a></p><p><br></p><p><a href="https://www.excelforum.com/excel-formulas-and-functions/1268423-sorting-an-excel-datasheet.html">https://www.excelforum.com/excel-formulas-and-functions/1268423-sorting-an-excel-datasheet.html</a></p><p><br></p><p><a href="https://chandoo.org/forum/threads/sorting-an-excel-datasheet.41196/">https://chandoo.org/forum/threads/sorting-an-excel-datasheet.41196/</a></p><p><br></p><p><a href="https://www.reddit.com/r/excel/comments/b110go/sorting_an_excel_datasheet/">https://www.reddit.com/r/excel/comments/b110go/sorting_an_excel_datasheet/</a></p><p><br></p><p><a href="http://www.msofficeforums.com/excel/41931-sorting-excel-datasheet.html">http://www.msofficeforums.com/excel/41931-sorting-excel-datasheet.html</a></p><p><br></p><p><a href="https://www.ozgrid.com/forum/forum/help-forums/excel-general/1216045-sorting-an-excel-datasheet">https://www.ozgrid.com/forum/forum/help-forums/excel-general/1216045-sorting-an-excel-datasheet</a>