=Transpose(A1:B3)
The transpose formula flips horizontal data vertically and flips vertical data horizontally. The transpose formula mirrors the data being referenced as stated above. So if you have data running 3 columns and 4 rows, the transpose formula mirrors that data over 3 rows and 4 columns. If you have data on 2 columns and 2 rows the transpose formula will display the data as 2 rows and 2 columns as it is equal in length horizontally and vertically.
So, the formula '=Transpose(A1:B3)' stems over 2 columns being A and B and 3 rows. So, to transpose the data in a formula, you would have to select 2 rows and 3 columns. So as an example, place some data in cells A1 to A3 and also in cells B1 to B3. Then highlight cells C1 to E2 and with the cells highlighted type =Transpose(A1:B3). Then without typing or clicking anything else hit Ctrl + Shift + Enter. The data will now be transposed horizontally into cells C1 to E2.
The transpose formula flips horizontal data vertically and flips vertical data horizontally. The transpose formula mirrors the data being referenced as stated above. So if you have data running 3 columns and 4 rows, the transpose formula mirrors that data over 3 rows and 4 columns. If you have data on 2 columns and 2 rows the transpose formula will display the data as 2 rows and 2 columns as it is equal in length horizontally and vertically.
So, the formula '=Transpose(A1:B3)' stems over 2 columns being A and B and 3 rows. So, to transpose the data in a formula, you would have to select 2 rows and 3 columns. So as an example, place some data in cells A1 to A3 and also in cells B1 to B3. Then highlight cells C1 to E2 and with the cells highlighted type =Transpose(A1:B3). Then without typing or clicking anything else hit Ctrl + Shift + Enter. The data will now be transposed horizontally into cells C1 to E2.
0 comments:
Post a Comment