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

[gunnie]

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

 

[alansidman]

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]

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]

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.