Tag Info

New answers tagged

1

Short Answer Use arrays in Google Sheets and SORT() function. Example To combine the non continuous ranges A1:D5, H1:K100, P1:S15, the following formula will return a 4 X 120 array sorted by the first column in ascending order. =SORT({A1:D5;H1:K100;P1:S15},1,TRUE) The first parameter also could be any function that returns an array like IMPORTFEED. ...



Top 50 recent answers are included