Duplicate Columns Using Power Query

Excel in 2016 has a new set of features known as Get & Transform or in earlier versions it is known as Power Query. It provides a platform to perform a series of steps to help you to transform your excel data. There is one step which will allows you to do is to duplicate columns easily.

Previously in Power QueryHow to Import Data from Text Using Power Query or Get & Transform?

If you want to duplicate or make some changes to it in your query editor but not in the source data. For example, I’ll show you this source data in that you can see the marked column, I want to duplicate them here to show you. It is going to be very easy for you to do this within few steps.


First you need to turn you selected data into an Excel Table by pressing this shortcut Ctrl + T or by going to Insert > Table.

Duplicate Columns

STEP 2: Open Power Query

If you are using Excel 2016:

Go to Data > From Table (Under Get & Transform)

Or if you are using Excel 2013 & 2010:

Power Query > Excel Data > From Table

STEP3: Duplicate Columns

This will open the Power Query Editor on your screen.

So, now select those columns you wanted to duplicate.

And then follow: Go to Add Column > General > Duplicate Column

Duplicate Columns
Make sure you select the column you want to duplicate.

Now, Click on Close & Load to export to your current sheet;

Duplicate Columns