Is there a way to concatenate a range of cells in Numbers?
let say e.g. I have the following table
and I want to have for each column the concatenation of all cells, as shown bellow
is there a more elegant way than using the concatenate formula like this ?
(I have a table of ~300x200, and this solution doesn't seems sustainable)
MacBook Pro with Touch Bar
The alternate solution, using the concatenation operatoR (&), is no more 'elegant.'
A1&A2&A3&A4&A5&A6&A7&A8&A9&A10&A11&A12&A13&A14&A15
Or you could use a cumulative concatenation process on separate table, like this:
Table 1, on the left, contains entered data in all rows except the last, A17.
A17 contains a formula that is a simple cell reference to the last cell (A16) on Table 2.
A17: Table 2::A16
Cell A1 of Table 2 is left empty, or may contain a null string,
A2 contains the formula shown below the tables, filled down to A16:
A2: A1&Table 1::A2
Results are as shown.
Regards,
Barry
The alternate solution, using the concatenation operatoR (&), is no more 'elegant.'
A1&A2&A3&A4&A5&A6&A7&A8&A9&A10&A11&A12&A13&A14&A15
Or you could use a cumulative concatenation process on separate table, like this:
Table 1, on the left, contains entered data in all rows except the last, A17.
A17 contains a formula that is a simple cell reference to the last cell (A16) on Table 2.
A17: Table 2::A16
Cell A1 of Table 2 is left empty, or may contain a null string,
A2 contains the formula shown below the tables, filled down to A16:
A2: A1&Table 1::A2
Results are as shown.
Regards,
Barry
Concatenate a range of cells in Numbers
