Forum Discussion
Solved
combining names from multiple rows to single cells
I am not even sure how to tackle this inquiry, it is something I have never had to perform before. I was provided a mailing list of over 33,000 records, I have filtered the common records out to wor...
SergeiBaklan I was playing with that - but you have just saved me tons of trial and error!! thank you Sergei, that's the query I was looking to accomplish!
thank you so much!
As variant, with Power Query you may Group By without aggregation all columns by FNAME; extract values from FNAME with delimiter; split resulting column using this delimiter keeping only first two columns.
SergeiBaklan I was playing with that - but you have just saved me tons of trial and error!! thank you Sergei, that's the query I was looking to accomplish!
thank you so much!
marie_pbi , you are welcome, glad to help