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.
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.
STEP1: Insert TABLE
First you need to turn you selected data into an Excel Table by pressing this shortcut Ctrl + T or by going to Insert > Table.
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
Now, Click on Close & Load to export to your current sheet;