Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
TTL
New Member

How to combine 2 tables with different column names and multiple duplicate rows

Hello all,

Just starting with Power tools and I'm trying to combine 2 tables with power query/pivot. One table have about 10 columns and the other have about 25 columns. The column names are all different but I can manually change the names to match and delete the extra columns. The columns also have duplicate/multiple rows as it is test data for same sample but at different time/ different samples but at same time (for example, various combinations of test sample 1, 2, 3, etc with test data at day 1, 2, 3, etc.).

Thank you!

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Hi @TTL 

 

Depends how you want to combine them.

 

If you are happy to rename columns so they match in both tables, and delete columns so that you have the same number in both tables, then you can Append the tables into one.  Go to Home tab->Append Queries.

 

That will preserve all rows from both tables but obviously not all columns.

 

If you want to preserve all columns but not necessarily all rows, then you can Merge the tables but you need at least 1 column in each table that can be matched to each other.

 

From there you can do more cleaning up but without seeing the data it's hard to say more.

 

Regards

 

Phil

 

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

1 REPLY 1
PhilipTreacy
Super User
Super User

Hi @TTL 

 

Depends how you want to combine them.

 

If you are happy to rename columns so they match in both tables, and delete columns so that you have the same number in both tables, then you can Append the tables into one.  Go to Home tab->Append Queries.

 

That will preserve all rows from both tables but obviously not all columns.

 

If you want to preserve all columns but not necessarily all rows, then you can Merge the tables but you need at least 1 column in each table that can be matched to each other.

 

From there you can do more cleaning up but without seeing the data it's hard to say more.

 

Regards

 

Phil

 

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.