![How would I get CONCAT to concatenate only values from a certain row and a certain column? It works on the first cell but not the rest (screenshot included, more info in How would I get CONCAT to concatenate only values from a certain row and a certain column? It works on the first cell but not the rest (screenshot included, more info in](https://i.redd.it/sqqbqfa71qm91.png)
How would I get CONCAT to concatenate only values from a certain row and a certain column? It works on the first cell but not the rest (screenshot included, more info in
![Moving at the Speed of Creativity | Use a Google Docs Spreadsheet to Send Text Message Alerts to Students Moving at the Speed of Creativity | Use a Google Docs Spreadsheet to Send Text Message Alerts to Students](http://farm7.static.flickr.com/6067/6087136212_7b11193494.jpg)
Moving at the Speed of Creativity | Use a Google Docs Spreadsheet to Send Text Message Alerts to Students
![Googlefinance function for Dividend Stock Info: Google sheets using YAHOO finance for Dividends! - YouTube Googlefinance function for Dividend Stock Info: Google sheets using YAHOO finance for Dividends! - YouTube](https://i.ytimg.com/vi/o7KJhNLa8kU/maxresdefault.jpg)
Googlefinance function for Dividend Stock Info: Google sheets using YAHOO finance for Dividends! - YouTube
![concatenation - Google Sheets: What's a way to concatenate strings in the same way as SUMIFS adds numbers? - Stack Overflow concatenation - Google Sheets: What's a way to concatenate strings in the same way as SUMIFS adds numbers? - Stack Overflow](https://i.stack.imgur.com/H3PXm.png)