1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sorting an excel datasheet

Discussion in 'Ask an Excel Question' started by AydanAr, Mar 14, 2019.

  1. AydanAr

    AydanAr New Member

    Messages:
    2
    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

    Attached Files:

  2. bosco_yip

    bosco_yip Excel Ninja

    Messages:
    2,191
    Please Don't Cross Posting

    and, please read the forum rule :

    • Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.

    • If you do cross-post, please put the website link in your post.

    • Also if you have cross-posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

    Regards
    Bosco
  3. AydanAr

    AydanAr New Member

    Messages:
    2

Share This Page