Transposing Data

Use the data transposing function to transpose cells across columns into rows and also reverse this process.

Sometimes, you might want to rearrange the way your data looks. For example, if your project data has the Height, Width, Depth, and Weight columns, you can use this function to transpose these four columns into two columns: Dimension and Measurement and reverse the transposing process.

Two transposing methods are available:

Transposing Cells Across Columns into Rows
Transposing Columns by Key/Value