The result set will have three columns, column1, Two and Three — where Two contains values from table1.column2 and table2.column4 and Three contains values from table1.column3 and table2.column5.

In this tutorial, I’ll show you how to use Microsoft Excel Power Query to combine values into a single cell, within groups. SEE: Windows, Linux, and Mac commands everyone needs to know (free PDF ...