+ Reply to Thread
Results 1 to 1 of 1

Consolidate Mixed Data into a single line on a new tab based on matching data in a column

  1. 02-15-2020, 01:04 PM #1
    symaxf
    symaxf is offline
    Registered User
    Join Date
    08-19-2010
    Location
    Arizona, USA
    MS-Off Ver
    Excel Mac 2011
    Posts
    59

    Consolidate Mixed Data into a single line on a new tab based on matching data in a column

    Hello Experts!

    Because a picture is worth a thousand words, I added a sample spreadsheet. I want the 'before' data to look like the 'after' data. If a matching ID is found in Col B then consolidate all rows into a single row. The source is a google sheet with thousands of rows. I would like a Google Sheets formula but I suppose an Excel formula would be just as good. Anyway, I'm not smart enough to figure this out and any help I can get with it would be a blessing.
    Attached Files Attached Files
    Last edited by symaxf; 02-15-2020 at 01:21 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Transfer and consolidate data from multiple line items to within single cell
    By Noah14 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2015, 10:43 AM
  2. Consolidate Rows of Data Based on Single Column
    By orutulsa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2014, 09:03 AM
  3. Consolidate data from multiple files in a directory by matching column headings
    By ezra_kirivann in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-21-2014, 11:46 AM
  4. VBA helps needed to consolidate data from multiple sheets by matching Column header
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-31-2013, 03:30 PM
  5. Consolidate Data Set, to Organize by Leading Column and single data set
    By jham808 in forum Excel General
    Replies: 0
    Last Post: 05-21-2012, 08:47 PM
  6. consolidate data into a single column
    By jyj9ja in forum Excel General
    Replies: 5
    Last Post: 01-19-2012, 03:22 PM
  7. stacked column/bar chart w/ monthly data + single line of daily data
    By dommarsh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-06-2008, 11:29 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1