Flitering + logical tests

[altuss]

Dear all,

I have been doing the following problem:

I have a table
[TABLE="width: 320"]
<colgroup><col span="5"></colgroup><tbody>[TR]
[TD]Name [/TD]
[TD]Training[/TD]
[TD]welcome[/TD]
[TD]day[/TD]
[TD]night[/TD]
[/TR]
[TR]
[TD]mark[/TD]
[TD]welcome[/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]mark[/TD]
[TD]two[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]mark[/TD]
[TD]day[/TD]
[TD] [/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]mark[/TD]
[TD]some[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Polyak[/TD]
[TD]day[/TD]
[TD] [/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Polyak[/TD]
[TD]night[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Polyak[/TD]
[TD]one[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Polyak[/TD]
[TD]two[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]avril[/TD]
[TD]day[/TD]
[TD] [/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]avril[/TD]
[TD]night[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

So in the main field whenever the training for a person matches one the three trainings names in the header row, it returns one.
I want to have only one row for a person, but so that all the trainings he/she did will be dispayed in the same row with 1 (and not having 3 rows with mark), like this:
Name Welcome Day Night
Mark 1 1
Polyak 1 1
Avril 1 1

Can somebody help me with the formulas needed for such an operation in excel?

I was thinking of doing something like while the name is still mark, check matching the header columns with trainings row, and return one if they match.

I would be very thankful!