### Welcome! Enter below articles or choose one from the menu above

#### Do Until Loop

In this article we are going to learn about programming DO UNTIL loops. First we are going to learn what loops are and why they are necessary. Then we are going to learn how to use a DO UNTIL LOOP.

#### Anova two factor with replication

Anova means Analysis of Variance. In this Excel tutorial you will teach yourself how to perform Anova in Excel. It will be Anova two factor with replication test.

#### How to compare columns to find duplicates?

In this lesson you will learn how to find duplicates in Excel. This is quick way to search bunch of data in just a second.

#### Correlation chart

Correlation helps to identify the pattern of change between two variables. It has two properties – strength and direction. It is a common statistics concept which can be easily represented in excel using a scatter plot and trend line.

#### Do while loop

In this article we are going to learn about programming DO WHILE loops. First we are going to learn what loops are and why they are necessary. Then we are going to learn how to use a DO WHILE LOOP.

Note: In excel VBA they are two types of DO LOOPS: DO WHILE and DO UNTIL. Our focus will be on the DO WHILE loop in this article

# How to consolidate tables with Power Query?

In this Excel lesson you will teach yourself how consolidate tables with Power Query. This is wonderful way to boost your efficiency and save bunch of time.

I have a worksheet. There are a few tables in there and I'd like to combine them into one table. Power Query will help me with that.

To join tables click Power Query in the ribbon menu. Choose From File - From Excel.

Choose the file in your local drive.

Power Query Navigator window pops out.

Select the whole file and click Edit.

I can see every objects in the whole workbook. I'd like to load only tables. So I need to click Kind and filter only tables.

Next I'd like to remove obsolete columns. I don't need so many of them.

To merge tables I need to press a small icon next to Data header.

I unchecked Use original column name as prefix option. Just because I don't like it.

This is how preview of my consolidated tables looks like.

Here is the time for final formatting.

First thing is to change the name. I did it on the right side of the screen.

Next important thing is to set proper columns data formatting. Click the small icon in the top headers and set right data type for each column.

When you are happy from your merged tables, and I am happy, click Close & Load To in the left top side of the screen.

I'd like to have Table in the New worksheet. Click Load to get merged tables in the new sheet.

And here is how my joined tables by Power Query look like.

I saved a bunch of time because now I have joined tables which don't require any more formatting.