I have a .csv table named mailing.csv as below. It consist a receiver,
subject and sender.

      Receiver                                subject       sender
1   Adrian Cole    RE: [WHIRR-117] Composable services    Tom White
2   Adrian Cole    RE: [WHIRR-117] Composable services    Tom White
3   Adrian Cole    RE: [WHIRR-117] Composable services  Adrian Cole
4   Adrian Cole    RE: [WHIRR-117] Composable services  Adrian Cole
5   Adrian Cole    RE: [WHIRR-117] Composable services    Tom White
6   Adrian Cole    RE: [WHIRR-117] Composable services  Adrian Cole
7   Adrian Cole    RE: [WHIRR-117] Composable services    Tom White
8   Adrian Cole    RE: [WHIRR-117] Composable services    Tom White
9   Adrian Cole    RE: [WHIRR-117] Composable services  Adrian Cole
10  Adrian Cole    RE: [WHIRR-117] Composable services  Adrian Cole
11  Adrian Cole    RE: [WHIRR-117] Composable services    Tom White
12  Adrian Cole    RE: [WHIRR-117] Composable services    Tom White
13  Adrian Cole    RE: [WHIRR-117] Composable services    Tom White
14  Adrian Cole    RE: [WHIRR-117] Composable services    Tom White
15 Patrick Hunt RE: [WHIRR-123] Cassandra integration     Tom White
16 Patrick Hunt RE: [WHIRR-123] Cassandra integration   Andrei Savu
17 Patrick Hunt RE: [WHIRR-123] Cassandra integration   Andrei Savu
18 Patrick Hunt RE: [WHIRR-123] Cassandra integration     Tom White
19 Patrick Hunt RE: [WHIRR-123] Cassandra integration     Tom White
20 Patrick Hunt RE: [WHIRR-123] Cassandra integration   Adrian Cole
21 Patrick Hunt RE: [WHIRR-123] Cassandra integration     Tom White22
Patrick Hunt RE: [WHIRR-123] Cassandra integration  Patrick Hunt

What I would like to do is to update/map the information from table
above to .csv template (namedAC_template.csv), and save it in a
separate file using subject details in backet as file name (for
instance AC_WHIRR-117). As for table above, it should create two new
files name as AC_WHIRR-117and AC_WHIRR-123.

sample .csv template (AC_template.csv) is as below:

                Adrian.Cole Patrick.Hunt Andrei.Savu Bruno.Dumon
Edward.J..Yoon Eugene.Koontz Jakob.Homan Kelvin.Kakugawa Tom.White
Adrian Cole               0            0           0           0
       0             0           0               0         0
Patrick Hunt              0            0           0           0
       0             0           0               0         0
Andrei Savu               0            0           0           0
       0             0           0               0         0
Bruno Dumon               0            0           0           0
       0             0           0               0         0
Edward J. Yoon            0            0           0           0
       0             0           0               0         0
Eugene Koontz             0            0           0           0
       0             0           0               0         0
Jakob Homan               0            0           0           0
       0             0           0               0         0
Kelvin Kakugawa           0            0           0           0
       0             0           0               0         0
Tom White                 0            0           0           0
       0             0           0               0         0
Lars George               0            0           0           0
       0             0           0               0         0
Soren Macbeth             0            0           0           0
       0             0           0               0         0
                Lars.George Soren.Macbeth
Adrian Cole               0             0
Patrick Hunt              0             0
Andrei Savu               0             0
Bruno Dumon               0             0
Edward J. Yoon            0             0
Eugene Koontz             0             0
Jakob Homan               0             0
Kelvin Kakugawa           0             0
Tom White                 0             0
Lars George               0             0
Soren Macbeth             0             0

Sample output for this question is as below:

sample output for AC_WHIRR-117:

                Adrian.Cole Patrick.Hunt Andrei.Savu Bruno.Dumon
Edward.J..Yoon Eugene.Koontz Jakob.Homan Kelvin.Kakugawa Tom.White
Adrian Cole               0            0           0           0
       0             0           0               0         9
Patrick Hunt              0            0           0           0
       0             0           0               0         0
Andrei Savu               0            0           0           0
       0             0           0               0         0
Bruno Dumon               0            0           0           0
       0             0           0               0         0
Edward J. Yoon            0            0           0           0
       0             0           0               0         0
Eugene Koontz             0            0           0           0
       0             0           0               0         0
Jakob Homan               0            0           0           0
       0             0           0               0         0
Kelvin Kakugawa           0            0           0           0
       0             0           0               0         0
Tom White                 9            0           0           0
       0             0           0               0         0
Lars George               0            0           0           0
       0             0           0               0         0
Soren Macbeth             0            0           0           0
       0             0           0               0         0
                Lars.George Soren.Macbeth
Adrian Cole               0             0
Patrick Hunt              0             0
Andrei Savu               0             0
Bruno Dumon               0             0
Edward J. Yoon            0             0
Eugene Koontz             0             0
Jakob Homan               0             0
Kelvin Kakugawa           0             0
Tom White                 0             0
Lars George               0             0
Soren Macbeth             0             0

Sample output for AC_WHIRR-123

              Adrian.Cole Patrick.Hunt Andrei.Savu Bruno.Dumon
Edward.J..Yoon Eugene.Koontz Jakob.Homan Kelvin.Kakugawa Tom.White
Adrian Cole               0            1           0           0
       0             0           0               0         0
Patrick Hunt              1            0           2           0
       0             0           0               0         4
Andrei Savu               0            2           0           0
       0             0           0               0         0
Bruno Dumon               0            0           0           0
       0             0           0               0         0
Edward J. Yoon            0            0           0           0
       0             0           0               0         0
Eugene Koontz             0            0           0           0
       0             0           0               0         0
Jakob Homan               0            0           0           0
       0             0           0               0         0
Kelvin Kakugawa           0            0           0           0
       0             0           0               0         0
Tom White                 0            4           0           0
       0             0           0               0         0
Lars George               0            0           0           0
       0             0           0               0         0
Soren Macbeth             0            0           0           0
       0             0           0               0         0
                Lars.George Soren.Macbeth
Adrian Cole               0             0
Patrick Hunt              0             0
Andrei Savu               0             0
Bruno Dumon               0             0
Edward J. Yoon            0             0
Eugene Koontz             0             0
Jakob Homan               0             0
Kelvin Kakugawa           0             0
Tom White                 0             0
Lars George               0             0
Soren Macbeth             0             0

Appreciate help from the expert...

	[[alternative HTML version deleted]]

