Until now combining many columns into a single one was a cumbersome process. Here is a formula seen in the web to stack columns with native Google Sheets function: =QUERY(ArrayFormula(SPLIT(TRANSPOSE(SPLIT(textjoin("-",TRUE,TRANSPOSE((A1:H1&","&A2:H5))),"-")),",")),"Select * where Col2<>''") Not very comprehensive, isn't it? Use =๐ฆ๐ง๐๐๐๐๐ฅ๐ฅ๐๐ฌ(๐๐ผ๐๐ฟ_๐ฎ๐ฟ๐ฟ๐ฎ๐) and stack your columns or rows instantly wherever you need it in your spreadsheet. Without altering the initial array. โถ๏ธ ๐๐๐๐๐ ๐ข๐จ๐ง ๐ข๐จ๐ฅ ๐๐๐ ๐ข https://docs.google.com/spreadsheets/d/1YBMUfJPbePUffEddtpzL2nMstkHzCcf_tjbKu6LR5kI/ ๐ ๐ข๐ฅ๐ ๐ข๐ฃ๐ง๐๐ข๐ก๐ฆ... โ Use =STACKARRAY(your_array, TRUE) in order to remove all blank cells โ Stack row by row instead of column by column =STACKARRAY(ref_to_your_array, , TRUE) โ To merge an array with unique values only, use =UNIQUE(STACKARRAY(your_array)) โ To sort the resulting column, use =SORT(STACKARRAY(your_array)) Find out more... https://nodatanobusiness.com/add-ons/stackarray