+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Combining multiple text strings based on contents of another cell

  1. #1
    Registered User
    Join Date
    03-20-2012
    Location
    SF Bay Area, CA, USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Combining multiple text strings based on contents of another cell

    I have a two columns which I am currently concerned with. Column A is an error number and column B is an error message. Column A has duplicates (one error number with multiple error messages).

    Is it possible to output the combined column B text strings into a single cell when they share the same value in column A? Obviously this can be done manually, but with thousands of errors per week, it takes too much time.


    Thank you!

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Combining multiple text strings based on contents of another cell

    Hi daunless,

    Welcome to the forum.

    See the attached file where I have tried creating your scenario and with the help of a pivot table, tried to combine the different error message together if they are having similar error number. Let me know if this helps you to start on. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    Attached Files Attached Files
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

+ 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