I am building a tracking sheet in Numbers for when I need to send my clients lists. I can't seem to figure out how to build a text string that contains information from all of the cells in one row.
I have columns that contain the subject's name, whether or not they have done an action and then the url to their personal gallery.
The last column is a formula to put together the name, , url link.
What I want to do is have a footer cell that then puts all of those text strings together.
Sum doesn't work on cells with text.
How can I add all of the text strings in all of the cells in one column together, without having to manually input each cell into a formula?
Some projects have 5 rows, which isn't too bad. However, the job I am currently attempting to track has 70 people.
It gets a little unwieldy to have to build a formula of A2&" "&B2"&etc etc etc.
Can I automate that in Numbers?