SOLVED

How to Create Relationship on a mac

Copper Contributor

Does anyone know where the "Create Relationship" option is when using a mac.
I'm using a macbook pro and my Excel version is 16.80.
For context, I want to be able to create a relationship between a column in a table that stores data and another table that translates the key into its actual meaning.

Example:

data table:
dept | employee |  salary
  2     |   Janet.      |  $57,000
  1     |  Brad         |  $67,500

department key table:
number | department
    1        | Accounting
    2        | Sales

I would like to create a relationship between the "dept" column in the first table and the "number" column in the second table. So when I eventually make a pivot table, I would be able to easily summon the actual department name of each employee. Thanks.

 

 

3 Replies
best response confirmed by Warren_Source (Copper Contributor)
Solution

I don't think you can do that with Mac Excel. Yet.

Show your expected result clearly according to your source tables.

I think you're right. I looked for it on Windows and it was plainly there in the data tab. Thank you.

1 best response

Accepted Solutions
best response confirmed by Warren_Source (Copper Contributor)
Solution

I don't think you can do that with Mac Excel. Yet.

View solution in original post