Data transpose Dynamically in Excel
Transpose function is use to exchange the data from Row to Column and Column to Row. To make your data get update automatically by using transpose function please follow the below mentioned steps.
STEPS :
Select destination range. (Where you want to transpose data)Type formula =transpose(source data range)Press Ctrl + shift + enter
4. See the result in below image. Data transposed within the selected range.
5. When we edit the source data, the transposed data will changed automatically. See the image below.