Forum Discussion
Solved
Power Query TextJoin
I import a sorted two column list in power query. Column A contains the product codes Coumn B contains a category that the product code belongs to. A given product code will belong to several cate...
Maviso69 You need to go to advanced editor and then use the GroupedRows step/code, I have uploaded the file here https://drive.google.com/file/d/1M6ULVsU3m_IJc08CupGCwbJXCcVyGPDe/view?usp=share_link to give you an idea.
Wow! - way beyond my programming ability at this point so will happily cut & paste to try. Intersting that your code doesn't appear to require "Column A" to be sorted either. Will try in the morning now. Many thanks