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!
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
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks