How to add Columns with more data than another column - Merge Files

[Richard199415]

Hi Everyone,

I'm trying to combine/merge two data sets from two different sources, I have two identical fields (Account Number & Invoice Number) that are shown in both files/tables but the rest of the fields are different and have different number of Rows, How can I merge this data to have all information matching the fields Account Number and Invoice Number?, below is an example of the two sources and the final output (I highlighted the data that should be added). Thank you!

 File 1 (Attached as CompanyDataExample)

Account number	Invoice Number	Company Product Number	Company Product Name	Item Amount
123456	963	Code1	Name1	10.99
[Null]	[Null]	Code2	Name2	50.99
[Null]	[Null]	Code3	Name3	60.99
[Null]	[Null]	Code4	Name4	0
741852	852	Code1	Name1	10.99
[Null]	[Null]	Code4	Name4	100.5
[Null]	[Null]	Code6	Name6	5.99

File 2 (Attached as Customer Data Example)

Account number	Invoice Number	Customer Product Name	Item Amount
123456	963	Customer ProductName1	15.99
[Null]	[Null]	Customer ProductName2	54.99
[Null]	[Null]	Customer ProductName3	62.99
[Null]	[Null]	Customer ProductName4	0
[Null]	[Null]	Customer ProductName5	10.99
[Null]	[Null]	Customer ProductName6	100
741852	852	Customer ProductName1	15.99
[Null]	[Null]	Customer ProductName2	54.99
[Null]	[Null]	Customer ProductName3	62.99
[Null]	[Null]	Customer ProductName4	0

Desired Output:

[ArtApa]

Hi @Richard199415 - Here is a possible solution: