filmov
tv
Transpose Function Tutorial in Excel
Показать описание
Transpose Function Tutorial in Excel
How to use the TRANSPOSE function in Excel? Transposing or moving data from horizontal to vertical is something that is necessary to get your data in the correct format. The TRANSPOSE() function is an array function which means you will have to hold down Ctrl & Shift and Enter to make this formula work.
You will then see little curly brackets, or braces, within the formula which indicates that an array formula has been entered.
What's more you can counteract that dreaded 0 or allow the range to take into account other cells by including an if statement nested inside the transpose function.
#computertutoring #datatablesforwhatifanalysisexcel #exceltutorial #transposeexceldata
😊 Check out my website and social media to keep up to date - enjoy learning 😊
How to use the TRANSPOSE function in Excel? Transposing or moving data from horizontal to vertical is something that is necessary to get your data in the correct format. The TRANSPOSE() function is an array function which means you will have to hold down Ctrl & Shift and Enter to make this formula work.
You will then see little curly brackets, or braces, within the formula which indicates that an array formula has been entered.
What's more you can counteract that dreaded 0 or allow the range to take into account other cells by including an if statement nested inside the transpose function.
#computertutoring #datatablesforwhatifanalysisexcel #exceltutorial #transposeexceldata
😊 Check out my website and social media to keep up to date - enjoy learning 😊
0:00:17
0:05:52
0:04:51
0:06:09
0:02:51
0:00:35
0:08:53
0:04:44
0:03:49
0:08:35
0:00:19
0:04:05
0:00:58
0:00:16
0:05:19
0:00:51
0:00:23
0:00:38
0:02:24
0:05:33
0:00:33
0:00:20
0:00:47
0:00:11