Pivot the keys of several columns into a column called "day" and their values into a column called "temp":

PivotToColumns can then be used to separate the columns for high and low temperatures:

Take a Tabular object of populations of the G7 countries:

Pivot the country column names and population values into new columns "Country" and "Population":

Take tabular data of weekend temperature and sun information:

Pivot the "high" and "low" columns of temperature values:

Pivot "sunrise" with "high" and "sunset" with "low":

Alternatively, pivot "sunrise" with "low" and "sunset" with "high":

When the sets of different value columns have different lengths, both names and values are filled in with Missing:

Create a Tabular object with measurements of soil pH at three depth levels of 0, 30 and 80 meters:

Pivot the depth values to create "depth" and "pH" columns and then sort by depth:

Find mean pH for each depth:

Take rectangular data organized by years and months:

Pivot the month columns into a "month" column and "data" column:

It is now easy to compute yearly means:

Take tabular data of weekend temperature and sun information:

Pivot two sets of columns at the same time:

Changing the order of the rules will change the order of columns:

Take tabular data of weekend temperature and sun information:

Simultaneous pivoting is not equivalent to using the same rules in consecutive separate steps:

Use PivotFromColumns on a Tabular object:

PivotToColumns is effectively the inverse of PivotFromColumns:

Remove the common part in ExtendedKey to recover the original object: