How to Transpose a Data Array in Microsoft Excel

by Dave Andrews ; Updated September 18, 2017

To transpose a data array in Microsoft Excel, which converts a column to a row or a row to a column, type in the transpose formula and the range of cells to be formatted. Transpose a data array in Excel with information from an experienced software developer in this free video on computers.

About the Author

Dave Andrews is a software developer with a business and Web site selling programs and other computer services in Franklin, Tenn. Having worked in the IT industry for more than 8 years, Andrews has an intimate understanding of computer technologies. He holds a degree in computer science from Middle Tennessee State University with a minor in mathematics. Andrews began working with computers when he was nine years old, programming BASIC on a Precomputer 2000. He now programs in C/C , Java, Microsoft .Net, ASP, Python and PHP and has written large, integrated program used by clients as large as state governments. Andrews is currently employed by a government IT department and enjoys the public service and constant challenge that such a position provides.