Append text from multiple cells in subsequent rows

  • Cross posted on mrexcel: https://www.mrexcel.com/board/…-subsequent-rows.1154617/


    Hi Folks,

    I've got a spreadsheet of codes and descriptions. Some descriptions only fall on one row, others are longer and fall into multiple rows (sometimes up to 60+ rows). I'm trying to figure out a way to easily append the text from those code descriptions over multiple rows into the top line for that code

    Example:


    CODELINE NUMBERDESCRIPTION
    2651This description continues for
    2652multiple lines and I need
    2653to combine them into a single
    2654cell where code=265 and line number=1
    3651This line also continues below
    3652but stops at two lines
    7651This description thankfully only takes up one row



    Any help here would be greatly appreciated because I've got 18000 rows * 15 separate sheets that need to be completed the same way

    Thanks in advance!

  • See if this works for you


  • See if this works for you


    Almost worked perfectly, but I lost some leading 0s on some codes. Another user on MrExcel was able to come up with a solution as well that is working perfectly for me though.


    Thanks so much for the help, interesting to see the similar but different paths to get to the same output!