Apache OpenOffice (AOO) Bugzilla – Issue 80600
ability to collapse data from a row / column of cells into a single cell (comma delimited), and vice-versa
Last modified: 2013-08-07 15:12:27 UTC
It would be useful to be able to highlight a row or column of cells, right-click, and select an option that would then move all the data in those cells to the first cell, separated by commas. Likewise, it would be useful to do the reverse: to be able to highlight a cell with commas (or a customizable separator?), and then expand it out into columns or rows.
Hi, the second part will be possible for OOo2.4 (Menu Data - Text to Column) the first part has to pass through the requirements team but IMHO the effort is not worth the outcome. Too few people would have a benefit from it. Frank