cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
djalexr
Helper I
Helper I

Power Query transformation - Append columns within ONE query

Hi there,

I have data organised a bit like this - I just want to take the last three columns and place them directly underneath the first three, like this...

 

PQ HELP.PNG
Though  I don't want to create two seperate queries and append them! For the real life problem this would mean creating a  huge amount of individual queries

 

Any ideas most appreciated! 🙂

 

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@djalexr , see if approach of this blog can help

https://kohera.be/blog/power-bi/how-to-unpivot-twice/



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
v-janeyg-msft
Community Support
Community Support

Hi, @djalexr 

 

I have a simple method, just duplicate a table, delete the merged rows in the corresponding table, change the name, and append queries.

Like this:1.gif

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User IV
Super User IV

@djalexr , see if approach of this blog can help

https://kohera.be/blog/power-bi/how-to-unpivot-twice/



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.