I have data that needs to be in a relational database but I only have Excel.

Name
Association (many to many with Name)
Committee (many to many with Name) - no relation to Association
Committee Role

I can't see how to combine these into one sheet and still be able to run a
Pivot table after.

My initial thought is store the data on two sheets. I was hoping to avoid
typing the name on both sheets. A person does not necessarily have a
committee or an association.

Sheet: Association

Name
Association

Sheet: Committees

Committee
Committee Role

Any advice?

Thanks