+ Reply to Thread
Results 1 to 7 of 7

Merge of data and grouping required retaining original result of merged data

  1. 01-23-2019, 09:34 PM #1
    troywhite1111
    troywhite1111 is offline
    Registered User
    Join Date
    01-21-2019
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    16

    Merge of data and grouping required retaining original result of merged data

    Hi All.

    Either with a formula or Power Query.

    How do I merge COL D together with a comma separating each value and grouping it by COL A

    I also want to keep COL F unique and display in the new table which shows the result for each record in COL D

    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-24-2019, 02:03 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,806

    Re: Merge of data and grouping required retaining original result of merged data

    I'm struggling to visualise what you are describing. Please manually add an 'after' table to your workbiook to show us what you are after.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 01-24-2019, 02:25 AM #3
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Merge of data and grouping required retaining original result of merged data

    This looks like the reverse of your other thread here.

    https://www.excelforum.com/excel-gen...-the-same.html

    Is it?
    Dave
    Reply With QuoteRegister To Reply
  4. 01-24-2019, 02:53 AM #4
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Merge of data and grouping required retaining original result of merged data

    Does this right?

    If you have Textjoin, Please try

    Index row
    I2
    =IFERROR(AGGREGATE(15,6,ROW(Table1__2[ #All])/(FREQUENCY(MATCH(Table1__2[E]&Table1__2[RESULT],Table1__2[E]&Table1__2[RESULT],),ROW(Table1__2[ #All])) > 0),ROWS(I$2:I2)),"")

    J2:O2
    =INDEX(Table1__2[A],$I2)
    If you don't like helper column replace I2 with the formula after iferror

    M2 press Ctrl+Shift+Enter

    =TEXTJOIN(",",,IF((J2=Table1__2[A])*(O2=Table1__2[RESULT]),Table1__2[D],""))

    Copy I2:O2 down


    Power Query

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  5. 01-24-2019, 03:35 AM #5
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Merge of data and grouping required retaining original result of merged data

    If you have Textjoin, Please try
    Bo the OP doesn't.

    If this helps I use this for my "cheat sheet"

    https://www.excelfunctions.net/excel...habetical.html
    Reply With QuoteRegister To Reply
  6. 01-24-2019, 03:54 AM #6
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Merge of data and grouping required retaining original result of merged data

    Thanks, Dave.
    This is just in case OP may not update profile. OP just join 2 days ago.
    Reply With QuoteRegister To Reply
  7. 01-24-2019, 04:19 AM #7
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Merge of data and grouping required retaining original result of merged data

    LOL. Been there, done that.
    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. [SOLVED] Caculating back from the result to the original data to find out the factor used
    By zookeepertx in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-25-2015, 02:00 PM
  2. Macro to find matching cells, then merge, and add data to show row was merged
    By hambly in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-19-2013, 02:24 PM
  3. Need a Macro to create salary slip in another sheet only for required data like mail merge
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-11-2013, 07:00 PM
  4. Saving workbook as notepad using cell data for filename & retaining original workbook name
    By peterkerr_13 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-26-2012, 08:07 AM
  5. Retaining original formatting on cell being copied to
    By Alkemac in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-15-2009, 04:59 AM
  6. Retaining original values with IF function
    By frutz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-16-2009, 10:48 PM
  7. [SOLVED] retaining original column widths in excel
    By GCope in forum Excel General
    Replies: 0
    Last Post: 09-26-2005, 02:05 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