I recently watched a video that showed how to combine two worksheets together with a relationship, so that you could create a pivot table using the data from both sheets. The error I am getting is the " both columns contains duplicate values" message but it does not make since. On the video I watched they combined the two worksheets using a column on each sheet that had the same header and the same data. I checked and the two columns are almost identical with multiple shared values and duplicate data. When I try to combine them it works fine, but on my workbook I get the error message. Is there something simple I am not seeing? A formatting issue or something?
Bookmarks