0

Merging Two Tables

Matthew Lee

March 26, 2021 22:51

None

Follow

Hello

 

I have created two tables using Table Builder function (Sales Invoice Line & Sales Cr.Memo Line) and I want to merge two table as one and have an excel table that includes all lines from both Sales Invoice and Sales CrMemo.

 

Could anyone help me on how I can achieve this?

 

Thank you!

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Bryan Robinson March 30, 2021 16:02

  You won't be able to do this with Jet and would probably require use of PowerQuery https://trumpexcel.com/merge-tables/ 

• 0
  
  Ruth Entwistle April 09, 2021 16:11

  You can put two NL functions on top of each other. 

   

  =@NL("Rows","Sales Invoice Line","Document No.")

  =@NL("rows","Sales Cr.Memo Line","Document No.")

   

  Then create a pivot from the results