Power Query transformation - Append columns within ONE query

[Anonymous]

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...

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! 🙂

[v-janeyg-msft]

Hi, @Anonymous 

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:

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 · Accepted solution]

@Anonymous , see if approach of this blog can help

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