Forum Discussion
Power Pivot - Duplicate Column Values
Hi, I'm attempting to create relationships between Category Fields and the corresponding Value Fields. The issue I'm running into is that Excel triggers the "Relationship cannot be created becau...
Data model in Excel doesn't support many-to-many relationship. Common practice is to build bridge table, but from your screenshot it's not clear which relationships and which tables you try to build.
SergeiBaklan Thank you for your reply. An example is attached.
There's one table that lists all of my different fields in one column and the corresponding category (that I would like to toggle with a slicer) with in the other column.
Another table has those fields labeled as column headers in the top row with the values below. Each row corresponds to a different product (size).
Including screenshots of the tables and my relationships.