Pivot Table + Array + Transpose or dont know what? HELP!

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


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.

HI Mario,

Although your sample has the solution, I was unable to apply it to my data. I tried copy-pasting the formula as you mentioned. I know I am missing something here. I do not understand most of the functions and the concept of relative and absolute reference, which you have used in your formula.

If it is possible to guide more elaborately, it will be really helpful.

Alternatively, is it possible to achieve this in Base?

Hi gm,
do you get the Pivot table working?
Have you enter the formula with Ctrl+Enter no only Enter?