The material provided is for informational purposes only, and should not be relied on in making any purchasing or investment decision. The information is not a commitment, promise or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at our sole discretion. © 2026 Cloud Software Group LLC. All rights reserved. This page and your use is governed by these
Terms of Use.
Even with the new data wrangling (tested with 10.2) you cannot get to a good result. I tried to unpivot, then calculate a new column using RowID() and ranked it over each ex-row-header. Then did the pivot over the ranks, but then the new columns are not sorted numerically, but as a text, so 1,10,100,1000,1001...
So a real Transpose is still needed.