+ Reply to Thread
Results 1 to 3 of 3

Move column after another column with Power Query

  1. #1
    Forum Contributor
    Join Date
    10-06-2017
    Location
    Europe
    MS-Off Ver
    2013
    Posts
    108

    Move column after another column with Power Query

    Hello all,

    I hope everyone is fine and healthy

    I have a small problem and maybe you can help me solve it.
    So everyday i receive an excel file that looks just like the attached one.

    What i want to do is to use Power Query (or any other method except copy paste), in order to move column C and D at the end of column A and B.

    Any suggestions?
    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,186

    Re: Move column after another column with Power Query

    In Power Query
    1. Load your table to PQ
    2. Remove columns C and D
    3. Open the left window of PQ where it says Queries
    4. Highlight your table and right click. Select Reference
    5. Delete all steps in the new table except source
    6. Change the name of the columns to the same as in the first table
    7. Append the second table to the first.
    8. Close and Load to Excel.

    My file attached for your review
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    10-06-2017
    Location
    Europe
    MS-Off Ver
    2013
    Posts
    108

    Re: Move column after another column with Power Query

    Thank you so much for your effort alansidman,

    Everything is just perfect
    It seems that PowerQuery is indeed very powerful

    Have yourself a great weekend

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 10
    Last Post: 06-25-2020, 12:19 AM
  2. [SOLVED] Power Query to Split a Column
    By andrewc in forum Excel General
    Replies: 5
    Last Post: 07-27-2019, 01:00 PM
  3. Custom Permutations Column in Power Query from two columns in the same Query
    By PaintPaddy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2019, 02:48 PM
  4. [SOLVED] Move From Column To Row - Power Query?
    By Gtrtim112 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-31-2019, 05:04 PM
  5. [SOLVED] Power Pivot does not load new column added in Power query
    By ibuhary in forum Excel General
    Replies: 12
    Last Post: 02-19-2019, 03:53 AM
  6. Adding Column in Power Query
    By fuerte in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-28-2018, 12:39 PM
  7. Replies: 4
    Last Post: 04-26-2018, 11:35 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1