Forum Discussion
textjoin
Hi. first of all sorry for my english I have a sheet with 365,000 rows. I need to concatenate the values in column D where the cells in columns A, B and C have the same values.
Does the screenshot show the intended result? This is done with Power Query and in the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
I've only made a small sample table however Power Query is the perfect tool for huge databases. It can actually handle transformation of several million rows.
Thank you very much, this is what I need. but I don't know how to apply Power Qury to my table :-) . Now I try