+ Reply to Thread
Results 1 to 2 of 2

Concatenate a range based on what is in another cell/range

  1. #1
    Registered User
    Join Date
    05-30-2019
    Location
    Texas
    MS-Off Ver
    365
    Posts
    3

    Concatenate a range based on what is in another cell/range

    Hi Everyone!

    I have a table where an employee's job title is split up into individual words, in different cells. What I want to do is concatenate those cells somehow so the entire Title is in each cell, for each employee. I have attached an image where the original data table is on top and the desired table is on the bottom-- I replaced real names with office characters :D


    My logic so far: create a new column with formula -- if the Employee Name<>Employee name above, then concatenate any cells in Column C, tied to that name. After that, Go To Special > Blanks > Fill up. I just don't know how to do a concatenate with a dynamic range

    If there is an easier approach to this please let me know!


    Concatenate.PNG

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    12,915

    Re: Concatenate a range based on what is in another cell/range

    Attached is a sample that uses the following formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    To apply this method to your data please upload the spreadsheet from which the screen shot was made by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Concatenate range based on Criteria
    By erice in forum Excel General
    Replies: 5
    Last Post: 01-12-2019, 09:24 PM
  2. Formula to concatenate date range based on several factors
    By bre_says in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-12-2018, 12:54 PM
  3. Replies: 10
    Last Post: 11-04-2015, 05:19 AM
  4. [SOLVED] UDF concatenate randomly chosen cells from range (Horizontal Range)
    By cheesefry in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-15-2014, 03:54 AM
  5. Concatenate a range based on Criteria
    By nuruedriss in forum Excel General
    Replies: 1
    Last Post: 11-06-2013, 10:32 AM
  6. Concatenate a Range based on cell values
    By nuruedriss in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-05-2013, 01:03 PM
  7. [SOLVED] Copy data from a range of cells into a blank range based on common cell
    By vanmeterkj in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-03-2012, 10:18 AM

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