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