+ Reply to Thread
Results 1 to 2 of 2

Join a string of text from cells in the same column where another cell matches

  1. #1
    Registered User
    Join Date
    03-22-2015
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    42

    Join a string of text from cells in the same column where another cell matches

    I have a very large spreadsheet with columns A-M. Each row has an ID number (A), a description (B) and three columns relating to action (Type of Action (C), Action itself (D), Who authorised (E), Authorised Date (F) and Completion Date(G)).

    What I want to do is have a formula or method to automatically join together the text in Columns C-G and place that text in Column H, BUT only where the Id number in Column A is the same. Please see example below. The number of rows varies for each ID. I don't actually need Columns C-G in the final output if that makes it easier but they can be left in if too complex. Hope this makes sense!

    Example

    001 Broken Furniture Repair Furniture sent for fixing TBrookes 1 October 2015 5 October 2015
    001 Broken Furniture Replace Furniture unable to be repaired. Replacement ordered Tbrookes 6 October 10 October 2015
    002 Low Beam Replace Contractor called to replace beam JSwift 30 September
    002 Low Beam Replace Contractor advised waiting on parts. T Brookes 5 October 2015

    Results

    A B C D E F G H
    001 Broken Furniture Repair Furniture sent for fixing TBrookes 1 October 2015 5 October 2015 Repair Furniture sent for fixing TBrookes 1 October 2015 5 October 2015 Furniture unable
    to be repaired. Replacement ordered Tbrookes 6 October 10 October 2015
    001 Broken Furniture Replace Furniture unable to be repaired. Replacement ordered Tbrookes 6 October 10 October 2015
    002 Low Beam Replace Contractor called to replace beam JSwift 30 September Replace Contractor called to replace beam JSwift 30 September Replace Contractor advised
    waiting on parts. T Brookes 5 October 2015
    002 Low Beam Replace Contractor advised waiting on parts. T Brookes 5 October 2015



    Thanks in advance.

  2. #2
    Valued Forum Contributor
    Join Date
    08-07-2014
    Location
    Quito, Ecuador
    MS-Off Ver
    Excel 2016 & 365, Windows 10
    Posts
    511

    Re: Join a string of text from cells in the same column where another cell matches

    @ tbrookes3

    It 's easier for forum memers if you attach a workbook with a sample of your problem.
    Annyway, I fix a code to do what you asked for.
    It is assumng your column H is empty, and ID Numbers only repeats in max two consecutive lines

    check the book attached here to see if it is what you need

    Join1.xlsm

    Vicho
    Barriers are there for those who don't want to dream

+ 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. Counting # of times keyword matches to a text string in a cell
    By abks in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-17-2015, 05:54 PM
  2. Copying all rows whose string column matches an input string.
    By yoshitsune in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2015, 03:27 AM
  3. VBA Hide row if cells in column F contains text string from cell A1
    By bone343 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-16-2014, 03:09 PM
  4. Replies: 1
    Last Post: 08-02-2012, 11:39 PM
  5. Replies: 2
    Last Post: 07-14-2011, 09:04 AM
  6. Replies: 3
    Last Post: 07-16-2010, 09:45 AM
  7. join text from multiple cells to one cell
    By stoey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2009, 06:28 PM

Tags for this Thread

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