Results 1 to 4 of 4

Concatenate based on text in a different column

Threaded View

  1. #1
    Registered User
    Join Date
    03-24-2014
    Location
    London,England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Concatenate based on text in a different column

    Hi,
    I am trying to get a complete list of applications per device. I have the device list but it is broken down into seperate lines so i would like some sort of formula (not fussed what type as long as it gets the desired results!) that will look in column A and if the text is the same, to concatenate the info in column b, seperated by a comma. So for the first device (4d713006) i would get 1 cell that would have the list of all 52 applications in it seperated by a formula. This is so i can vlookup the device name from another sheet and pull through all the list of applications.
    I hope this makes sense and any help would be appreciated! I have atttached the data :-)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Concatenate a column based on a column with matching rows
    By excelsior51 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-01-2013, 11:13 AM
  2. Pls help, can we concatenate text based on some criteria lik SUMIFS
    By Shermin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-22-2013, 04:31 AM
  3. Concatenate values in a column based on value of previous column
    By CountySurveyor in forum Excel General
    Replies: 3
    Last Post: 10-02-2012, 06:38 PM
  4. Concatenate multiple rows based on column value
    By sbartlett1123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2012, 05:58 PM
  5. Concatenate based on unique column combination.
    By samford in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-03-2010, 06:51 PM

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