• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Excel Tutorials

Microsoft Excel Tutorials

  • Home
  • Tutorials
  • Learn
    • Formulas
    • Power Query
    • Errors
    • Videos
    • Charts
    • Shortcuts
    • Pivot Tables
    • Macros
    • Basics
    • Analysis
  • 240+ Excel Shortcuts
  • Privacy Policy
You are here: Home / Power BI / Power Query / How to Duplicate Columns Using Power Query or Get & Transform?
How to Duplicate Columns Using Power Query or Get & Transform?

How to Duplicate Columns Using Power Query or Get & Transform?

posted on September 24, 2019

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 Query: How 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.

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.

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

Filed Under: Power Query

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Download 240+ Shortcuts

Microsoft Excel comes with varieties of keyboard shortcuts which are stated below with excel shortcut name and its keys for Windows and Mac.

Categories

  • Basics
  • Formulas
  • Pivot Tables
  • Charts
  • Power BI
  • Analysis
  • Shortcuts
  • Macros
  • Add-Ins

Recent Comments

  • Olivia on Convert Formulas to Values in Excel
  • Pkv on How to Insert Comment In Power Query Steps?
  • Rahul on How to Insert Comment In Power Query Steps?
  • David on How to Insert Comment In Power Query Steps?
  • sofia on How to use Workday Formula in Excel?

Footer CTA

Get Weekly Updates in your mailbox

Get Started Now

Copyright © 2021