1. Home
  2. Blog
  3. Office
  4. Excel PowerQuery Merge Datas

Excel PowerQuery Merge Datas

On 20/10/2023 0

In Office

How to join datas from Excel Tables

Create 2 Tables with a common column

01 createtables

 

 

 

 

 

 

 

 

Name your table

02 nameyourtable

 

 

 

 

 

Save Your table

03 savequery

 

 

 

 

 

 

 

Merge tables with a leftOuterJoin

05 mergequeries

 

 

 

 

 

 

 

 

 

 

 

 

 

Keep only required columns

 

06 keepgoodcolumn

 

 

 

 

 

 

 

 

Remove dupplicates

07 removedoublons

 

 

 

 

 

 

 

 

 

Results

 

08 results

 

Excel fusionner les données jointures

★ ★ ★ ★ ★
1 vote. Average rating: 5 / 5.

Add a comment

Anti-spam