Issue 64605

Summary: Creating a "transposed" summary list
Product: Calc Reporter: raindrops <na1000>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: OOo 2.0.2Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: FEATURE Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

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 requirements@openoffice.org 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.