Noob with a Excel 365 merge tables question - how to preserve the first tables order.

gunnie

New Member
Joined
Mar 22, 2019
Messages
2
Hi - I am a noob and this is my first post / question - hello to everyone

I am merging two tables together with the first column of each table being matched. The problem I am having is that when they merge together I loose the order of the first table.

How to I merge then together will preserving the original order of the first table? I have googled for hours and everyone was pointing to MrExcel as the place to go.

Cheers

Jase
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
6,877
Office Version
  1. 365
Platform
  1. Windows
I would use Power Query to merge the two tables. Without seeing the actual data or a representative sample, this is the best I can offer.
 

gunnie

New Member
Joined
Mar 22, 2019
Messages
2
Hi alansidman - thanks for taking the time to reply to me.

Yes - I used power query to help I will add what I am trying to do

Table one has a primary key & then a description of the product and finally the size i.e. 5678 Jack Burbon 700ml

Table two has the same primary key and include the number of items per carton i.e. 5678 24

I have created a merge to create a result of 5678 Jack Burbon 700ml 24

The issue I have is that I need to preserve the order of table 1 so that the merge of both tables is in the order of table 1

Apologies that I cannot provide screenshots as the images are not on the web.

Thanks in advance for any assistance that anyone can give

Jase
 

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
6,877
Office Version
  1. 365
Platform
  1. Windows
To be sure of the sort order, add a column of Index numbers to the first table. Run your merge and then sort the data on basis of the index column.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,714
Messages
5,833,276
Members
430,201
Latest member
Deepakpilla36

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top