Download the featured files here.
Old version https://www.bluepecantraining.com/wp-content/uploads/2021/01/Transpose-Data-Old-Version.xlsx

https://www.bluepecantraining.com/wp-content/uploads/2021/01/Transpose-Data.xlsx


In this video I demonstrate four ways to transpose data in Excel.
1) Transpose using paste special including shortcut key
2) Transpose using the TRANSPOSE function which works differently in different versions of Excel - I show you how to use it any version
3) Transpose using the paste links method
4) Transpose using the INDEX function.

I also demonstrate how to transpose dynamically so that if you add or change data the transposed version automatically updates.

This video answers the following queries:
How to transpose in Excel
How to use the TRANSPOSE function in Excel
How to transpose using a shortcut key in Excel
In Excel transpose rows to columns
How do you flip and transpose in Excel?
How do I transpose large data in Excel?
How do you reverse transpose in Excel?
Create dynamic transpose in Excel
In Excel, transpose formulas without changing references
In Excel, transpose based on cell value
In Excel, transpose links
In Excel transpose without array
------------------------