Merging two columns

[Anonymous]

Hi everyone,

I have more then two tables which are including same columns. I cant merge that data in one columns. For example; 

I associated the first column in all tables.  "Ekskavatör Gün" column is the same for every table but when I add that column from each table they came as different columns. I don't know how I will fix it. I use access for database. 

[AbhinavJoshi]

You cannot have two columns with the same name, change the name of column that conflicts of one of the tables, try renaming it. It should work! 

[Anonymous]

Hi @Anonymous ,

I have made a simple attempt. Please have a try.

Click on Home>>Transform Data>>Home>>Merge Queries>>Merge Queries as new.

Choose the same name columns>> Right click Merge columns.

Best Regards

Community Support Team _ polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Is there anyone to help me? 

[vivran22]

Hello @Anonymous ,

Where you are appending the tables?

Try changing the name of this column in Power Query. 

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂 (Hit the thumbs up button!)
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)


https://www.vivran.in/

Connect on LinkedIn

[Anonymous]

I tried but an error appeared which "the name is used as another  column name" sorry my English isn't perfect:) I provide data from an access database