JOIN text function over multiple ranges
I am trying to create a formula that will join a group of element IDs from two entire columns. My latest failed attempt is below:
=JOIN([Element 1 ID]:[Element 1 ID], [Element 2 ID]:[Element 2 ID], ", ")
I'm not sure if I just have the syntax wrong or if the JOIN function is not capable of including multiple ranges. I suppose I could have a formula for each column then join the resulting cells for one group, but I am hoping there is a less convoluted approach.
The goal is to be able to copy all of the Element IDs as a single string of text for pasting into another program.
Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!