By Andrew Gould

Download files here https://www.wiseowl.co.uk/excel/videos/excel-general/excel-transpose/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Learn how to use the TRANSPOSE function in Microsoft Excel to convert rows into columns and columns into rows.

Chapters
00:00 Topic list
00:25 Transposing a Row to a Column
01:22 Transposing a Column to a Row
01:47 Transposing Multiple Rows and Columns
02:18 Transposing Unique, Sorted Lists
03:24 Using the Results of the Transpose Function
05:23 Using TRANSPOSE with XLOOKUP

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!