Forum Discussion
Department info for users
I have a list of 365 Groups and their Owners, and another list of all staff and their department divisions.
I need to show the division of each Owner.
Thank you.
- If each "owner" owns only one Division you can do the following:
If not done so yet, convert both lists to a table (Start tab, Format as table).
Then select the main table (the one with the groups) and click Data, Relationships.
Click the New button
In the Table dropdown, select the table with groups
In the column(foreign) select the column containing the owners
In the related table dropdown , select the table with owners
In the related column select the column with owner names.
Press OK.
Now Select the either table and click Insert, Pivottable
Click the "More Tables..." text to display all tables and check the boxes next to the owner name and DIvision names.
2 Replies
- If each "owner" owns only one Division you can do the following:
If not done so yet, convert both lists to a table (Start tab, Format as table).
Then select the main table (the one with the groups) and click Data, Relationships.
Click the New button
In the Table dropdown, select the table with groups
In the column(foreign) select the column containing the owners
In the related table dropdown , select the table with owners
In the related column select the column with owner names.
Press OK.
Now Select the either table and click Insert, Pivottable
Click the "More Tables..." text to display all tables and check the boxes next to the owner name and DIvision names.