+ Reply to Thread
Results 1 to 2 of 2

Concatenate a column based on a column with matching rows

  1. #1
    Registered User
    Join Date
    07-31-2013
    Location
    denver
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Concatenate a column based on a column with matching rows

    a b c d e g h
    1019 1 John doe Water Sal 61-01547-9152 40
    1090 1 John doe Coop WAR 63-00597-000 2.57
    1091 1 Chocolate Coop WAR 63-01729-000 5.12
    1091 1 Chocolate Coop WAR 63-01990-000 68.178
    1091 2 Chocolate Coop WAR 63-01728-000 0.312
    1091 2 Chocolate Coop WAR 63-01730-000 2.02
    1092 1 Flower Cofe Moon 63-02014-000 5.5
    1126 1 Flower East Cow 27-02619-010 6.6


    So I'm trying to concatenate based on column A. Everything row in that column that is matching I would like to concatenate column G into the first origin of that matching row. Poorly explained I know, but for instance:

    Rows a3-6 match and ideally I would like them to look like.

    1091 1 Chocolate Coop WAR 63-01729-000, 63-01990-000, 63-01728-000, 63-01730-000 5.12
    1091 1 Chocolate Coop WAR 68.178
    1091 2 Chocolate Coop WAR 0.312
    1091 2 Chocolate Coop WAR 2.02

    Not sure if that is even possible. Any help would be greatly appreciated!

  2. #2
    Registered User
    Join Date
    05-21-2013
    Location
    UK
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    86

    Re: Concatenate a column based on a column with matching rows

    Doesn't look like a standard function will sort it (prepared to be shown I'm wrong here) but this may help:
    http://www.cpearson.com/excel/stringconcatenation.aspx
    If I've helped or inspired, please click the star.

+ 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. Replies: 12
    Last Post: 02-21-2013, 12:55 PM
  2. Move Rows of Data from a Specific Column (Based on Matching Criteria) to a new Sheet
    By jordan1214 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2013, 02:30 AM
  3. Deleting Rows based on matching values in column A, in two different worksheets
    By Insert Name in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-11-2013, 08:39 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 row values based on Column “A” merged rows
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-16-2011, 01:51 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