Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Creating a "transposed" summary list|
|Component:||programming||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||FEATURE||Latest Confirmation in:||4.1.0-dev|
Description raindrops 2006-04-21 10:36:20 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.
Comment 1 raindrops 2006-04-21 13:18:11 UTC
OOps! Please change the issue type to "feature request".
Comment 2 dridgway 2006-04-28 05:53:13 UTC
Sounds like a feature request for CONCATENATE as an aggregation function for Data->Subtotals or Data->Consolidate. Issue type changed.
Comment 3 oc 2008-07-15 10:43:36 UTC
reassigning features and enhancements to user email@example.com which will be the default owner for those tasks (was introduced some time ago)
Comment 4 wkhan 2009-06-25 04:41:06 UTC
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
Comment 5 raindrops 2009-06-25 16:08:58 UTC
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.
Comment 6 Edwin Sharp 2014-01-02 19:23:56 UTC
Perhaps a Pivot Table with no function, just list.