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, Inc. All rights reserved
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.