Hi Guys,
At my work i am dealing with large excel with multiple data. is there anyone can help me to achieve required result. (check attachment)Attachment 798977Attachment 798977
Raw table is Raw data from inhouse system, but required last table (changes in column c only).
Product ID is primary key, but column c need to combined if primary key is same and separate with comma ", " .
acceptable?
Case ID Description Fault(s) ABC123 DVD Player Do not power up, Scratches, Dents, Power cable, Remote XYZ234 65 Inch TV Screen crack, Remote missing, Power cable DFC987 FloorMate Water damage, Torn, NIL
Should be alright, but better to have exact how I did it in excel.
Your help will be highly appriciate.
no formula but Power Query
Please Login or Register to view this content.
You mean with all these blank Description and Fault(s) ?
Yes please,
There are others column(s) in between them which I remove here. But real scenario I need those. So required Blanks in Description and fault(s). same as in excel.
Thanks,
Last edited by TirthShah; 10-03-2022 at 10:58 PM.
it works with your example
post REAL structure with data (can be generic data) or wait for someone else to solve your problem
is that what you want?
Case ID Description Fault(s) ABC123 DVD Player Do not power up, Scratches, Dents, Power cable, Remote ABC123 ABC123 ABC123 ABC123 ABC123 XYZ234 65 Inch TV Screen crack, Remote missing, Power cable XYZ234 XYZ234 XYZ234 DFC987 FloorMate Water damage, Torn, NIL DFC987 DFC987 DFC987
Yes, exactly that's I won't. Please let me know the formula.
Look at Sandy's workbook to see the MCode he has used inside the query.
Here's the code:
Please Login or Register to view this content.
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.
or:
=A5:B18&""
and
=IF(G5<>"",TEXTJOIN(", ",,FILTER($C$5:$C$18,$A$5:$A$18=F5)&""),"") - copied down.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks