How to Transpose Across Sheet In Excel

Welcome to Excel Jet Consult blog post. In this post we want to learn how to change the order of data using the TRANSPOSE array function.

TRANSPOSE Function converts a vertical range of cells to a horizontal range or vice versa.

TRANSPOSE Syntax                         =TRANSPOSE(array)

We want to transpose the data in the caption below

To transpose, we will select corresponding range of empty cells which is 5 columns and 20 rows

Type in =TRANSPOSE with open parenthesis and select the values in the next sheet

=TRANSPOSE(Records!A2:T6)

Execute CTRL + SHIFT + Enter

Task completed

 

Posted in Blog.

Leave a Reply

Your email address will not be published. Required fields are marked *