Closed Thread
Results 1 to 4 of 4

Concatenate values in a column based on value of previous column

  1. #1
    Registered User
    Join Date
    09-28-2012
    Location
    Illinois
    MS-Off Ver
    Excel 2010
    Posts
    5

    Concatenate values in a column based on value of previous column

    Hello,

    I have a scenario I need some help with. The goal is to get values from one colum into one cell,in a linear format, based on a value in the same row, but a different column.

    Example:

    If the value in column I is equal to value of M5, then insert the value of column J in the same row as the previously matched value in column I.

    There will be multiple matches found in the column and i need them to be displayed in a linear fashion separated by a space so they can be recognized by another program.

    The number of values in column N5(the target for the data) will vary based on the number of matched values.

    The end result would be something like $J5 $J6 $J7 $J8 $J9 $J10 $J11...

    I'm kind of new to excel so please be forgiving, Thanks!

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Concatenate values in a column based on value of previous column

    Welcome to the forum.
    is your problem same as this?
    http://www.excelforum.com/excel-form...tml?highlight=

    regards,
    Vladimir
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Registered User
    Join Date
    09-28-2012
    Location
    Illinois
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Concatenate values in a column based on value of previous column

    Yes, actually they are both my posts. I didn't think this one posted due to the firewall at our office, so I posted the second. Sorry about that.

  4. #4
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Concatenate values in a column based on value of previous column

    Closing thread. Discussion may be continued in the other one.

Closed 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