Forum Discussion
Solved
Pivot/Transpose Issue
Hello all, On the left is my current table. I want it to look like the table on the right. (I manually created a sample for reference, but my table has over 7000 rows so I can't manually create t...
Just updated my previous post (download the Updated version please)
A Sort step wasn't at the right place in terms of efficiency
What is the new file supposed to show me?
- Exactly the same thing. As I mentioned earlier the query is more efficient in the Update version
- I'm sure I'm having a slow moment, but I'm not sure what you mean by "the query." I see two tables, a before and after. What steps did you take to get to the after?
Initially you said When I transpose it in PQ so I assumed you were a bit familiar with Power Query
Please go the Data (tab) > Queries & Connections (the corresponding pane opens on the right) > Double-click on query Table1_Updated. (the Power Query Editor will open). From there you can follow the steps