I have a table in org-mode with emails in one column. I want to collect all the emails as a comma-separated list, but I don't know an easy way to do it. It seems like something fairly simple, but I can't find a solution anywhere on the web.
What would be the simplest way to do it?
Dipping my toes slightly into org mode, a very simple formula of @1.. will do the trick of making a list from the values in the current column from rows 1 onwards, as it simply joins the values by commas by default. e.g.:
#+TBLFM: @5$2=@1..
(followed by C-cC-c to evaluate), would create a list in row 5, column 2, of all the values in column 2.
It does wrap the list in square brackets, but that's obviously no problem for a manual approach.