Can I Use Join/Collect in a Row Range?

Brian McElligott

I have a sheet that has many columns, and I need to pull data from specific columns if the value is not blank. Can I use a Join / Collect formula to pull the data in specific columns into a single column for reporting?

Example:

My goal is to have a list of Items, skipping the cost data points.

Carson Penticuff

Join/Collect can get a little tricky when you only want to use certain cells/columns, but in this case we can get around that by specifying only cells that are text in the collect:

=JOIN(COLLECT([Item A]@row:[Item B Cost]@row, [Item A]@row:[Item B Cost]@row, ISTEXT(@cell)), ", ")

Brian McElligott

Thank you Carson. I learn more from community champions all the time.

Carson Penticuff

Happy to help! 👍