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...
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
- Ahhhh. I see. My experience with PQ is very limited. This is the first time I've used Queries and Connections by someone else.
Either way, THANK YOU! It worked. You are heaven bound!