Results 1 to 3 of 3

concatenate cells and delete rows with a twist

Threaded View

  1. #1
    Registered User
    Join Date
    06-05-2009
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2003
    Posts
    3

    concatenate cells and delete rows with a twist

    I have a spreadsheet with three columns (check #, invoice #, vendor #). If a check pays multiple invoices, there is a separate row for each instance of invoice #. (ie if a check pays 10 invoices, there are 10 rows all with the same value for check # and vendor #, but different invoice #s). I need to concatenate the multiple rows to just one row per check #, with all the invoice #s in separate columns on the same row and delete the duplicate check # rows. However, I can only use 10 columns, so if there are more than 8 invoices matching the same check #, the 10th column will need to contain invoices 9-n concatenated and separated by a space.

    I have over 5000 rows in the spreadsheet.
    Last edited by rudyrod; 06-08-2009 at 09:20 AM.

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