Results 1 to 8 of 8

Combine Data in Multiple Columns to One Column Based on Data in Rows

Threaded View

exceldivx Combine Data in Multiple... 09-08-2014, 03:43 PM
exceldivx Re: Combine Data in Multiple... 09-08-2014, 08:35 PM
boddulus Re: Combine Data in Multiple... 09-08-2014, 11:30 PM
exceldivx Re: Combine Data in Multiple... 09-09-2014, 06:03 AM
cs454 Re: Combine Data in Multiple... 09-09-2014, 06:25 AM
  1. #1
    Registered User
    Join Date
    09-08-2014
    Location
    earth
    MS-Off Ver
    2010
    Posts
    4

    Combine Data in Multiple Columns to One Column Based on Data in Rows

    Hi Excel experts!

    I have similar data spread across multiple rows that I would like to combine. Below is a simplified example:

    r15Yz2x.jpg

    I want to combine all of the names in column D, comma delimited, if they have the same information from other rows in columns A, B, and C. For example, Column A, B, and C of rows 2, 3, and 4 say Pizza, http://www.pizza.com, 1/12/2014. The difference comes in Column D of rows 2, 3, and 4. I would like to consolidate all of the names in Coilumn D that pertain to the information from the first three columns. Here is an example:


    1JP9KS6.jpg

    How can I accomplish this? Please see attached a sample workbook for the example I have created. My actual data is very large (1000+ rows)

    Example.xlsx
    Last edited by exceldivx; 09-08-2014 at 03:47 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combine multiple columns of data into one column
    By PMBottas in forum Excel General
    Replies: 8
    Last Post: 08-12-2014, 11:10 PM
  2. Replies: 6
    Last Post: 02-19-2014, 10:25 AM
  3. Combine multiple columns of data into one column???
    By seedman76 in forum Excel General
    Replies: 4
    Last Post: 03-07-2013, 02:20 AM
  4. Combine data from multiple rows into one row when other column data changes
    By nena473 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-22-2012, 03:56 PM
  5. Replies: 6
    Last Post: 05-03-2006, 04:30 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