+ Reply to Thread
Results 1 to 9 of 9

Sorting an excel datasheet

  1. #1
    Registered User
    Join Date
    02-27-2019
    Location
    Antwerp
    MS-Off Ver
    2019
    Posts
    13

    Sorting an excel datasheet

    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.

    ScreenShot_20190314193408.png --> The forum isn't letting me post links..
    Attached Files Attached Files
    Last edited by AydanAr; 03-14-2019 at 02:35 PM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    7,003

    Re: Sorting an excel datasheet

    So which of those 2 csv files is your input file?

    The bad way.png is a pretty useless file. It just lists the number 1.09 in a column and says it's the bad way. With no explanation.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Contributor
    Join Date
    10-30-2003
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    195

    Re: Sorting an excel datasheet

    Multiple cross posts without links ... (at least two)

    Regards
    Bosco

  4. #4
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,325

    Re: Sorting an excel datasheet

    Quote Originally Posted by Bosco View Post
    Multiple cross posts without links ... (at least two)

    Regards
    Bosco
    Make that at least three...

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,170

    Re: Sorting an excel datasheet

    Make that 4

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,052

    Re: Sorting an excel datasheet

    Administrative Note:

    Welcome to the forum.

    We would love to help you with your query; however, it has been brought to our attention the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
    Read this to understand why we (and other sites like us) consider this to be important.
    HTH
    Regards, Jeff

  7. #7
    Registered User
    Join Date
    02-27-2019
    Location
    Antwerp
    MS-Off Ver
    2019
    Posts
    13

    Re: Sorting an excel datasheet

    Hi Special-K

    I'm sorry for the incomprehensibility. It's just a way of showing the order of the rows. As I said in my post, the "SKU" column needs to be above the "parent_sku" column. That way the main product (SKU) is uploaded first and the variations (parent_sku) are linked to the main product. The excel file is my input file, afterwards it'll be converted into .csv as u see in the uploaded files (working product.csv).

    Kind Regards,
    Aydan
    Last edited by AydanAr; 03-14-2019 at 02:48 PM.

  8. #8
    Registered User
    Join Date
    02-27-2019
    Location
    Antwerp
    MS-Off Ver
    2019
    Posts
    13

    Re: Sorting an excel datasheet

    Cross posts included, didn't know there was such a thing. I'm sorry.

  9. #9
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,052

    Re: Sorting an excel datasheet

    Quote Originally Posted by AydanAr View Post
    Cross posts included, didn't know there was such a thing. I'm sorry.
    Most site have forum rules which you agreed to when you signed up. Our site specifically has this rule.

    https://www.excelforum.com/forum-rul...rum-rules.html

    And btw, a picture does not help at all. How about just pasting the clear text.

    chandoo.org/forum/threads/sorting-an-excel-datasheet.41196/

    That way, whoever may be helping you can check to see if they are wasting their time. Six forums. You've been a busy beaver.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Data sorting in large excel datasheet
    By Mary22 in forum Excel General
    Replies: 5
    Last Post: 07-19-2016, 11:10 AM
  2. Excel userform - vba code to modify datasheet
    By mariec_06 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-26-2016, 05:26 PM
  3. Linking excel datasheet and webpage columns
    By Rupinderpalsingh in forum Excel General
    Replies: 1
    Last Post: 03-05-2015, 04:55 AM
  4. VBA for display Various Datasheet data in Masterdatasheet when we choose datasheet name
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-08-2014, 10:21 AM
  5. How to automate emails and invoices from Excel datasheet
    By chalcott in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-18-2010, 02:50 PM
  6. VBA User Form with Excel datasheet
    By Tor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2008, 03:07 PM
  7. Regarding selection of every 4th row from a huge excel datasheet...
    By skonduru in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 09-10-2007, 12:32 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1