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
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,857
Office Version
  1. 2019
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
5,857
Office Version
  1. 2019
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,204
Messages
5,527,396
Members
409,759
Latest member
KCH

This Week's Hot Topics

Top