Hello friends,
Thanks for helping so far. Have tried lots of things, but could not come up with a solution. May be someone out there can help.
I want a data to be tabulated from:
TC Char
02:53 host
02:56 neil
03:05 rick
04:02 slim
06:01 host
07:15 neil
10:02 neil
to...
Char Count TC
host 2 02:53 06:01
neil 3 02:56 07:15 10:02
rick 1 03:05
slim 1 04:02
Any clues? There is lots and lots of data. Need a completely automated solution.
Hi grn,
find attached a sample file, using a Pivot Table to get the unique values and Array formulas to get the hours for every value.
PivotTable+Array+Transpose.ods
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-09-02 00:13:01 +0200
Seen: 116 times
Last updated: Jan 31
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
to a pivot table like this:
Char Count TC
host 2 02:53 06:01
neil 3 02:56 07:15 10:02
rick 1 03:05
slim 1 04:02
grn ( 2012-09-08 12:31:54 +0200 )edit