Hello,
I would need an Excel Expert to assist me. I have two Excel reports :
- Report of the payment
- Customer Nationality
The only unique identifier in the both of them is the CC numbers. I need to match those two reports using the CC numbers as unique identifier and add the column of the Customer Nationality to the Report of payment when the CC numbers match in the two reports. I was thinking using the Launch Query Power Editor, am I on the good track or the Launch Query Power Editor is not the solution ?
I would need an Excel Expert to assist me. I have two Excel reports :
- Report of the payment
- Customer Nationality
The only unique identifier in the both of them is the CC numbers. I need to match those two reports using the CC numbers as unique identifier and add the column of the Customer Nationality to the Report of payment when the CC numbers match in the two reports. I was thinking using the Launch Query Power Editor, am I on the good track or the Launch Query Power Editor is not the solution ?
