Transpose rows to columns but keep them linked
Transpose rows to columns but keep them linked.
The TRANSPOSE function allows you to change rows to columns or columns to rows and STILL KEEP THE LINKS TO THE ORIGINAL.
In the example below you need to highlight a column of cells that match the area of the row you want transposed and find the TRANSPOSE function in the function wizard.
To see the full course contents click here.