Transpose rows to columns but keep them linked

Please purchase the course before starting the lesson.

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.

TRANSPOSE ARRAY

To see the full course contents click here.

Back to: Advanced Excel Course > Key Lookup Functions