Sort Horizontally by Rows in Excel and Google Sheets
ฝัง
- เผยแพร่เมื่อ 25 ส.ค. 2024
- This video shows how to sort data or table horizontally or by rows in Excel or Google Sheets. Google Sheets does not support the same tool in Excel so we will use TRANSPOSE and SORT function to solve the problem.
You're such a genius! Thank you so much!
Works for Excel just as fine: =TRANSPOSE(SORT(TRANSPOSE(ROW(L30:Q35))),1,1))
hi thanks for this. i tried it on google and i get error "The result of the array was not expanded because it would replace data in cell F4." any ideas?