sample.xlsx
Hi all, any help is greatly appreciated. I have attached the the excel file for my query. As you can see from the excel sheet the column under Order ID there are duplicate data. I would like to merge these and the column under Description to have textjoin. Pls see After tab to show the result i would like to have. Any help will be greatly appreciated.
Last edited by Muneer1977; 08-13-2022 at 09:03 AM.
Welcome to the forum.
Please provide ONE samlple .xlsx file with a tab showing before and another tab showing after - make it easy for your helpers by keeping everything in one workbook, please.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thank you. will attach file like you mentioned.
In the attached I created your expected results using Power Pivot and a DAX measure.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Appreciate your help here. I have more of such data to consolidate. How do i add in more lines and refresh to pivot them all ?
or...
=TEXTJOIN(CHAR(10),,IF(Before!$A$2:$A$6=A2,Before!$C$2:$C$6,""))
(works in O365)
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
Hi Glenn, Good day to you sir, I added in more data to the file you sent me with the formula. I tried to drag down the formula to the newly added data. It does not seem to work. Can you assist me with this ?sample.xlsx
You need to change the range of the formula to include all of the data!!!
=TEXTJOIN(CHAR(10),,IF(Before!$A$2:$A$14=A2,Before!$C$2:$C$14,""))
You would refresh in the same manner as if your were using a regular pivot table. Add the records, go to Data and Refresh all
sample (3).xlsx
Tried refreshing and got error. Maybe i did something wrong. Can you help me out ?
Did you see Post 8??
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks