Results 1 to 5 of 5

Need to combine cells based on first cell

Threaded View

  1. #1
    Registered User
    Join Date
    02-27-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    22

    Need to combine cells based on first cell

    I am looking to do this; based off the value in the first column (A), I would like to combine the vehicles in column (F) that matches the part number in the A column.

    example:
    60-1000 = CHEVROLET S10 1982-1985 1.9,CHEVROLET S10 BLAZER 1983-1984 2,CHEVROLET S10 1983-1996 2.2,CHEVROLET S10 BLAZER 1985-1993 2.5,CHEVROLET S10 1982-1993 2.8,CHEVROLET S10 BLAZER 1988-1996 4.3
    60-1001 = BUICK CENTURY 1988-1989 2.8,PONTIAC 6000 1988-1988 3.1,BUICK CENTURY 1989-1989 3.3,BUICK CENTURY 1988-1988 3.8

    I am looking for this in the comma delimitted format, but I need to do this for all the numbers in column A without doing them one-by-one.

    Thank You
    Attached Files Attached Files

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