Dec 6, 2016

How to transpose a matrix table

Transposing a matrix table requires two EasyMorph transformations applied one after another -- Unpivot and Pivot:

Step 1: Load a sample table.


(click to zoom)

Step 2: Unpivot


(click to zoom)

Step 3: Pivot using another column for column labels.


(click to zoom)

Almost there.

Step 4: Sort to tidy up the table.


(click to zoom)