![]() ![]() Select the entire horizontal data that you want to sort.If you don’t need the original data, you can also manually transpose the data, sort it (just like you sort any vertical range of cells) and then transpose it back to get the horizontal data that has been sorted.īelow are the steps to sort this data horizontally: Sort Horizontally By Transposing the Data Manually If any cell in this range is already filled, the formula would give an error. For this formula to work, these cells where the result is expected should be empty. When you enter the formula and hit Enter, it will instantly fill the range of cells (which would be of the same size as that of the original data).You will have to delete the entire resulting range at once. You can not delete any individual cell or a range of cells in the resulting data. The result if this function is an array.Some important things to keep in mind when using the formula to sort horizontally in Google Sheets: This means that in case you change any of the values in the original data, it will automatically adjust the result to show the newly sorted data. The good thing about using a formula is that it makes the resulting data dynamic. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |