To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=64605 Issue #:|64605 Summary:|Creating a "transposed" summary list Component:|Spreadsheet Version:|OOo 2.0.2 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|programming Assigned to:|spreadsheet Reported by:|raindrops
------- Additional comments from [EMAIL PROTECTED] Fri Apr 21 02:36:20 -0700 2006 ------- 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
