00:00Here are two new functions available on Microsoft 365, the to call and to row function.
00:05Call simply converts your data set into a column of data, and the to row converts your data set
00:09into a row of data. Let me demonstrate. To use the to call, you're going to say equal to call.
00:13The first argument will be the data set, comma, one to ignore blank. To use the to row, you're
00:18going to say equal to row, and the first argument will be the data set, comma, one to ignore blank.
00:23And each of these arrays get dynamically updated when you make changes to the original data set.
00:27So where does the transpose function sit in all this? Well, transpose function basically rotates
00:32your data set table. Let me show you. If you have a six by three data set table, and if
00:36you put it
00:36through the transpose function like this, it will rotate it to three by six data set table. Okay,
00:41at this point, what can we possibly use this to function for? Well, generally, I put the to call
00:46array through the unique and sort function like this, and this would make for an excellent data
00:51validation list. But for to row function, I'm not really sure what I can use it for. How would you
00:56use the to row function array for? Let me know in the comment section.
Comments