Can the Arrange tool mimic the Transpose tool on certain scenarios?
Have you ever come across this? If not, you have to try it.
Some time ago I mentioned that the Arrange tool can mimic the Transpose tool to Mark Thompson @Watermark
Some time went by, and I kind of forgot about it, but I mentioned again to Alex Sepenu @KorkuSep , and I remembered again.
This is the approach.
Step 1: If you would like to follow along, get an arrange tool into the canvas and add a column with no Key Fields for grouping.
Spoiler
Step 2: The key is to name the Column Header: Value and the Description Header: Name.
In this process, you can also select as many columns to transpose in here.
Spoiler
Step 3: The additional requirement is that you have to type the name of the column in the Name column for all columns you select.
Spoiler
Step 4: For comparison purposes, you can bring a Transpose tool to the canvas and select the same columns to transpose with no groupings.
Spoiler
Optional Step 5: If you would like to transpose more columns with the arrange tool after adding the first column, you need to add rows and select the value from the drop down menu and type the name of the column in the Name column.
Spoiler
Here is the attached file with the example; please try it for yourself.
