+ Reply to Thread
Results 1 to 3 of 3

Consolidate data from rows to columns

  1. #1
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    581

    Consolidate data from rows to columns

    Hi all,

    Assume you have a rather large data set with products and their Best Before dates. There are duplicates in products column as the same product may have several best before dates. What I am trying to achieve is to build a report, where I have all the products in one column (no duplicates), but Best Before dates in several columns, depending how many of them are there. It isn't easy to explain, so I have drafted a dummy with how I desire the result to look like, Once you see it you will understand what I'm after.

    I don't mind either - formula or VBA approach, as long as it gives me the correct output.

    Thanks all in advance for your priceless ideas.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel365
    Posts
    2,502

    Re: Consolidate data from rows to columns

    Please try at I6 drag across and down

    =IFERROR(INDEX($E:$E,AGGREGATE(15,6,ROW($C$6:$C$99)/($C$6:$C$99=$H6),COLUMNS($I6:I6))),"")

  3. #3
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    581

    Re: Consolidate data from rows to columns

    Bulls Eye! Thanks Bo_Ry!!!

+ Reply to Thread

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