+ Reply to Thread
Results 1 to 7 of 7

Sorting question

  1. #1
    Registered User
    Join Date
    03-14-2019
    Location
    Seattle, Washington
    MS-Off Ver
    Office 365
    Posts
    3

    Sorting question

    Hi,

    I have a spreadsheet with Part #s in column A. There are quantities in column B associated with the part #s in column A.

    Example:

    Column A Column B
    SFTR-56 35
    SFYU-82 6
    WRR-83 18

    I’d like to pull the Part # onto a new tab of the spreadsheet and list it as many times as the quantity indicates. After that the second Part # listed as many times as that indicates and so on. All in a big long column.
    The goal is to use this second “deconstructed” list to use for printing labels.

    Hopefully that makes sense.

    Any help is greatly appreciated.

    Thanks!
    Keith

  2. #2
    Forum Expert
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    2013
    Posts
    3,252

    Re: Sorting question

    Hi & welcome to the board.

    How about
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-14-2019
    Location
    Seattle, Washington
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Sorting question

    Fluff13,

    Thanks for the response. I have to admit I need more specific instructions like what formulas to put in what cells.

    Thanks,
    Keith
    Last edited by jeffreybrown; 03-14-2019 at 07:06 PM. Reason: No need for full quotes! It's just clutter.

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2007
    Posts
    8,790

    Re: Sorting question

    Hi Keith,

    How about attaching a sample workbook.

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    HTH
    Regards, Jeff

  5. #5
    Valued Forum Contributor
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010
    Posts
    521

    Re: Sorting question

    Here is a formula based option.
    With reference to the picture below:
    Is this what you are looking for?
    Can you live with a helper column somewhere in the first worksheet?

    OneCol.png

    Sheet1!C2: The N() functions avoid having to make a special case of C2
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Sheet2!A2 and copied down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The attached workbook implements the above.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    03-14-2019
    Location
    Seattle, Washington
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Sorting question

    That worked. Thank you so much!! This helped me overcome a hurdle on an important project.

    Thanks also for the pointers on posting questions, such as attaching an excel file with what I'm looking for. I will heed that advice for the future.

    I've noticed many of the posts show "problem solved." Do I need to do something to check that box?

    Thanks again,
    Keith

  7. #7
    Valued Forum Contributor
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010
    Posts
    521

    Re: Sorting question

    Hi Keith. Thanks for the feedback and for thinking about flagging the problem as solved. To do this select Thread Tools from the menu link above your first post and mark this thread as SOLVED. Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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