#MELLEL TABLE MERGE CELLS HOW TO#

In the popped out Import Data, select Only Create Connection option, and then click OK button, see screenshot:ĥ. Then, in the Table1-Power Query Editor window, click Home > Close & Load > Close & Load To, see screenshot:Ĥ. After creating tables for each of the data ranges, then, select the first table, and then click Data > From Table / Range, see screenshot:ģ. If your data ranges are not table format, first, you should convert them to tables, please select the range, and then click Insert > Table, in the Create Table dialog box, click OK button, see screenshots:Ģ. To use the Power Query function for joining multiple tables into one based on the corresponding key columns, please do with the following step by step:ġ. Merge two or more tables into one based on key columns with an amazing feature Merge two or more tables into one based on key columns with Power Query function (Excel 2016 and later versions) This may be a troublesome task for most of us, but, please don’t worry, this article, I will introduce some methods for solving this problem.

Supposing you have three tables in a workbook, now, you want to merge these tables into one table based on the corresponding key columns to get the result as below screenshot shown.

#MELLEL TABLE MERGE CELLS HOW TO#

How to merge two or more tables into one based on key columns?

Mellel table merge cells