Apache OpenOffice (AOO) Bugzilla – Issue 64605
Creating a "transposed" summary list
Last modified: 2014-01-02 19:23:56 UTC
Often we have a machine-readable raw list that reads like this: ____________________________ Name Ticket ____________________________ John 3423498242 Barbara 1324234245 John 5676767756 John 0923424252 Barbara 4563345454 John 5647756757 ____________________________ From this list, we want to create a user-friendly "transposed" list, like this: John 3423498242 5676767756 0923424252 5647756757 Barbara 1324234245 4563345454 (I can't show cells here. Imagine that each entry is in its own cell.) Further, we can concatenate the cells to produce a tab-separated list(or a comma-separated list) like this: John: 3423498242, 5676767756, 0923424252, 5647756757. Barbara: 1324234245, 4563345454. Since the ticket numbers are unique, it is not possible to use any of the data functions to consolidate the list. In any case the idea is not to count or sum these fields; only to list (enumerate) them against each key value. Please provide such a facility.
OOps! Please change the issue type to "feature request".
Sounds like a feature request for CONCATENATE as an aggregation function for Data->Subtotals or Data->Consolidate. Issue type changed.
reassigning features and enhancements to user requirements@openoffice.org which will be the default owner for those tasks (was introduced some time ago)
This is an excellent and extremely useful feature: a new, or modified version of the CONCATENATE function. Even one that does a simple concatenation without grouping would be a huge step forward. I hope someone picks this up and adds it to the next release of OO Calc. Thanks, Will
I had suggested two different features: (a) transposed cells and (b) concatenated list. Even if the transposed summary is not provided, we can derive it easily from the concatenated list, as shown below: For example, I take- John: 3423498242, 5676767756, 0923424252, 5647756757. Barbara: 1324234245, 4563345454. And then use "text-to-column" command, with "comma" as separator. Each individual entry will be moved to a different cell.
Perhaps a Pivot Table with no function, just list.