# Tags
**Software** : [[02 - Tags/Software/Power Query]]
**Functions** used : [[Excel.CurrentWorkbook]] [[Table.PromoteHeaders]] [[Table.FromColumns]] [[Table.ToColumns]] [[Table.Demoteheaders]]
**Date** : 29-March-2025
# Description
👋 Hey there, Data Enthusiasts! 👋 📊 Welcome to another episode of Ba Sensei Power Query Tutorials! Today, we're diving deep into a game-changing technique: combining two tables WITHOUT using the Merge function! 🎉 🔗 Resources & Links 🔗
# Video Link
<iframe width="560" height="315" src="https://www.youtube.com/embed/xN28ewvXFKw?si=O24txOQuDwWMYMqn" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>
[GITHUB File Link](https://github.com/jbotes/powerbiTutorials/blob/main/PQ_Merge_Video.xlsx)
# M-Query
```mquery
let
Source = null,
Table1 = Excel.CurrentWorkbook(){[Name="StockCodes"]}[Content],
Table2 = Excel.CurrentWorkbook(){[Name="StockNames"]}[Content],
Custom1 = Table.PromoteHeaders(Table.FromColumns(Table.ToColumns(Table.DemoteHeaders(Table1)) & Table.ToColumns(Table.DemoteHeaders(Table2))))
in
Custom1
```
```mquery
(Table1, Table2)=>
let
Custom1 = Table.PromoteHeaders(Table.FromColumns(Table.ToColumns(Table.DemoteHeaders(Table1)) & Table.ToColumns(Table.DemoteHeaders(Table2))))
in
Custom1
```
```mquery
let
Source = null,
Table1 = Excel.CurrentWorkbook(){[Name="StockCodes"]}[Content],
Table2 = Excel.CurrentWorkbook(){[Name="StockNames"]}[Content],
Custom1 = TableStockFunction(Table1, Table2)
in
Custom1
```
## Optional Tags
**Tags** :
**Technique** : [[Custom Function]]