Combine tables error: The relationship cannot be created because both columns ... etc

[countryfan_nt]

Hello friends, Hope all is well. I have tried to figure this out over and over again, and I even followed the steps of the link below, but it just wont work.
https://chandoo.org/wp/2013/07/01/in...relationships/

I keep getting: excel relationships both selected columns contain .....

the attachment is here, can you please walk me through this? I can tell this will save time & can be a very useful function.

Thank you so much in advance

[protonLeah]

title updated

[sandy666]

Append tables via PowerQuery then create PivotTable

or read here: Relationships

[countryfan_nt]

Thank you very much, can i do it without powerquery? If so how? Please tell me how to avoid the error?

[sandy666]

Did you read info from the link? There is a good description of how relationships are created and between which tables

It is depend what are you tryin' to achieve with your PivotTable

Now you've assigned different Types to the same ID so you'll get error

maybe read here also: Database Normalization

Edit:
Also you can use Alt+D+P to create PivotTable from 4 tables

[countryfan_nt]

Ok after carefully reading The link i get it now, no duplicates.
Perhaps Choosing the function creating relationship was not the right approach. Allow me to start over.

All columns have the same nature headers and type of info every sheet has the last two columns contain different columns. I want 1 database in ‘pivot’ sheet and to treat it as
Database for pivottable and to avoid using vlookup.

In the end i have a database picking up all the columns that have common data and see info in the respective rows.

I hope I didn’t confuse you friends, if i did i am sorry and will make a new attachment with the sheet and the desired end result.

[sandy666]

try read this one to understand database/tables/relationships: Relational databases: Defining relationships between database tables and Primary key - Foreign key

in short: 1st table: different data with unique primary key, 2nd table: different data with unique ID but with foreign key related to the primary key from 1st table... etc.