+ Reply to Thread
Results 1 to 2 of 2

Merging rows into one cell where multiple instances exist

  1. #1
    Registered User
    Join Date
    07-23-2019
    Location
    PA, US
    MS-Off Ver
    2013
    Posts
    1

    Question Merging rows into one cell where multiple instances exist

    Let me start this by saying this may be a simple problem but I did a bit of research (likely using improper terminology) and couldn't find anything.


    I have a pricing sheet that lists prices per part number vertically rather than horizontally. There is also a space at the start of a price list so that it does not line up with the part number.



    Example: Part# Price$
    12345
    $99.00
    $87.00
    $88.00
    54321
    38574
    20094
    $26.00
    $28.00
    $23.99

    Where $99,$87,$88 correspond to A1 and $26,$28, and $23.99 correspond to A7.


    Is there any way I can merge all of the prices to the first blank cell above them?

    Example:
    12345 $99.00, $87.00, $88.00
    54321
    38574
    20094 $26.00, $28.00, $23.99

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Merging rows into one cell where multiple instances exist

    It's a bit tricky trying to figure out the exact formatting of your source data. It would be much clearer if you would 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.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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. How to output and list instances where a condition does not exist
    By Frodobongins in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-14-2018, 03:30 AM
  2. Replies: 3
    Last Post: 01-14-2018, 02:47 AM
  3. How to output and list instances where a condition does not exist
    By Frodobongins in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2018, 02:46 AM
  4. [SOLVED] Complex VLOOKUP, multiple instances vertical, return subsequent instances horizontally
    By Miles_2804 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-12-2013, 11:54 AM
  5. Replies: 1
    Last Post: 01-22-2013, 09:17 AM
  6. Merging multiple cell rows across two columns
    By vikhound in forum Excel General
    Replies: 3
    Last Post: 12-17-2009, 02:01 PM
  7. Merging Cell contents accross multiple rows
    By Sugar Ape in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-14-2009, 12:23 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