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
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
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
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.
@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!
Please acknowledge that you have read and understood my note above. Thanks.
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.
Yeah Sure !! I have understood. Going forward this won't happen.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks