Forum Discussion

175429's avatar
175429
Copper Contributor
Oct 28, 2024
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...
excel
Lorenzo's avatar
Lorenzo
Silver Contributor
Oct 29, 2024

175429 

Just updated my previous post (download the Updated version please)

A Sort step wasn't at the right place in terms of efficiency

  • 175429's avatar
    175429
    Copper Contributor
    Oct 29, 2024
    What is the new file supposed to show me?
    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Oct 29, 2024
      Exactly the same thing. As I mentioned earlier the query is more efficient in the Update version
      • 175429's avatar
        175429
        Copper Contributor
        Oct 29, 2024
        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?