linking multiple roles (rows) to a user (cell)
 

Hi

I am managing a conference database where some delegates have multiple
presentations and roles such as chairs, rapporteurs, etc.

I am having some difficulty designing this on Excel 2003, where I could use
the autofilter funcionality effectively, eg: if x does 1 and 2, how do I lay
it out? Do I:

1. Place 1 & 2 in the same column (roles) and 'merge and centre' 1 to cover
the two rows? The challenge with this approach is that there are many info
columns (demographics, accommodation, travel, etc.) attached to delegate x
that will also have to be merged.
2. Place 1 & 2 in adjacent columns (role1 & role2) in x's row. This makes
sense, but plays havoc with my filtering and reporting.

Can anyone help?

Yoesrie