Sorting an excel datasheet

AydanAr

New Member
Joined
Mar 14, 2019
Messages
1
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?file_id=02519710256564919153


Cross posted
https://www.excelforum.com/excel-formulas-and-functions/1268423-sorting-an-excel-datasheet.html
https://chandoo.org/forum/threads/sorting-an-excel-datasheet.41196/
https://www.reddit.com/r/excel/comments/b110go/sorting_an_excel_datasheet/
http://www.msofficeforums.com/excel/41931-sorting-excel-datasheet.html#post139421
https://www.ozgrid.com/forum/forum/help-forums/excel-general/1216045-sorting-an-excel-datasheet
 
Last edited by a moderator:

Forum statistics

Threads
1,081,470
Messages
5,358,874
Members
400,514
Latest member
JoHio2577

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top