+ Reply to Thread
Results 1 to 7 of 7

Grouping Data

  1. #1
    Registered User
    Join Date
    09-14-2022
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    8

    Post Grouping Data

    Hi All,

    I need to group data (in a column) based on the another column. Kindly let me know how it can be done. Attached the sample input and required output format.

    Thanks in advance !! Excel Doubt.jpgExcel Doubt.xlsx

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Grouping Data

    with Power Query

    Input Output
    Brand Color Brand All Colors Brand AllColors
    Apple Blue Apple Blue|Yellow Apple Blue | Yellow
    Apple Yellow Samsung Red Samsung Red
    Samsung Red Sony Red|Green|Blue Sony Blue | Green | Red
    Sony Red Lenovo Orange|Black Lenovo Black | Orange
    Sony Green Dell White Dell White
    Sony Blue
    Lenovo Orange
    Lenovo Black
    Dell White
    Attached Files Attached Files

  3. #3
    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
    79,369

    Re: Grouping Data

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...-data.1216473/)
    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.

  4. #4
    Registered User
    Join Date
    09-14-2022
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    8

    Re: Grouping Data

    @sandy666

    Thanks for the help !! If possible Could you please explain the steps in the power query (List, Extract & RC)
    Last edited by AliGW; 09-14-2022 at 07:11 AM. Reason: Please DON'T quote unnecessarily!

  5. #5
    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
    79,369

    Re: Grouping Data

    Please acknowledge that you have read and understood my note above. Thanks.

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Grouping Data

    Quote Originally Posted by KarthickDijo View Post
    @sandy666

    Thanks for the help !! If possible Could you please explain the steps in the power query (List, Extract & RC)
    in Power Query window open Advanced Editor and you'll see whole M-code
    or
    here is

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    09-14-2022
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    8

    Re: Grouping Data

    Yeah Sure !! I have understood. Going forward this won't happen.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 11-06-2020, 05:45 PM
  2. Replies: 6
    Last Post: 01-24-2019, 04:19 AM
  3. Replies: 0
    Last Post: 12-10-2015, 08:24 AM
  4. Replies: 4
    Last Post: 07-26-2014, 02:35 AM
  5. Replies: 6
    Last Post: 06-07-2012, 09:32 AM
  6. Want to get a Series with Grouping and Sub-Grouping based on 2 criterias.
    By e4excel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-02-2011, 05:46 AM

Tags for this Thread

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