The result of the SORT function is again fed into the TRANSPOSE function to get the horizontal data back which has been sorted. It then uses the SORT function to sort this data based on the second row (which becomes the second column in the transposed data).
The above formula uses the TRANSPOSE function to first transpose the data from horizontal to vertical. The below formula will sort the data horizontally in Google Sheets: =TRANSPOSE ( SORT ( TRANSPOSE ( B1:K2 ), 2, ) ) Suppose you have a dataset as shown below and you want to sort this data based on Student marks. While the SORT function by itself would only be able to sort data that is arranged horizontally, we can combine it with the TRANSPOSE function to convert a horizontal data into a vertical one. You can use a little bit of formula wizardry to sort the data horizontally. Sort Horizontally Using the SORT Function Sort Horizontally By Transposing the Data Manually.Sort Horizontally Using the SORT Function.
0 kommentar(er)
