R
robo
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
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