Hi,
>> Relationship cannot be created because each column contains duplicate values. Select at least one column that contains only unique values.
The table’s relationship error is coming from each column contains duplicate values. You need have at least one column that contains only unique values. You will need to eliminate the duplicate, otherwise the Power pivot will not work. One way for resolving
this issue is in your table use an aggregate function if these duplicate records are no useful. The simplest method is adding new column extra to my Excel sheet and using an auto number like SeanDza mentioned.
Here is a similar topic thread for your reference:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/78d3a631-efea-40b7-9e82-6fbe2f3239d1/excel-powerpivot-create-relationship-between-2-excel-tables-files-located-in-my-desktop
Regards,
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click
HERE to participate the survey.