Office

How to join datas from Excel Tables

Create 2 Tables with a common column

 

 

 

 

 

 

 

 

Name your table

 

 

 

 

 

Save Your table

 

 

 

 

 

 

 

Merge tables with a leftOuterJoin

 

 

 

 

 

 

 

 

 

 

 

 

 

Keep only required columns

 

 

 

 

 

 

 

 

 

Remove dupplicates

 

 

 

 

 

 

 

 

 

Results