View and multi value fields

Hello all,

I have two multi-value fields on a form: (1)workers and (2)hours.

For example:

Workers: Sonja Schmidt

     Mark Holm (new line separator)

Hours : 10; 5 (“;” separator)

In my view, I have workers as the first column, sorted and categorized. On another column, I want to show corresponding hours for each worker, like:

Sonja Schimdt

10

Mark Holm

5

And have a total hours calculated for each worker.

Does anyone know how to solve this problem?

Any help would be very much appreciated!

Sonja