Forum Discussion
Merging two columns
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.
5 Replies
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 LinkedInHi 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.
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!
