Transpose means two or more things changing their places with each other. For example, the TRANSPOSE in Excel formula flips data of the table array from horizontal to vertical and vice versa. =TRANSPOSE(array) The TRANSPOSE function changes the position of data, like the first row of the array becomes the first column, the second row becomes the second column, and so on. Only cell values are copied and shifted.