Text to Join - Using textJoin function in google spreadsheet
When the data is too long and there are several gaps in between data(Rows).
The TEXTJOIN function in Google Spreadsheet combines text from multiple ranges or strings using a specified delimiter. It allows for ignoring empty cells, making it ideal for consolidating data efficiently.