Merge Excel Files with Different formats

[michael.zura (GuardiansFan)]

@Orchestrator_Practice
Hello
I think with a little looking around this forum, the same question was asked, here is a starting point:

Can you join datatable without duplication?

Hello all! I’m trying to join two datatables which have the same exact columns, have matching rows, but have unique cell values. Table 1: ID | Name | Ticket 1 | John | 2 | Peter | 205 3 | Mary | Table 2: ID | Name | Ticket 1 | John | 301 2 | Peter | 3 | Mary | 564 When I attempted an inner join with matching ID, I got: ID | Name | Ticket | ID_1 | Name_1 | Ticket_1 1 | John | 301 | 1 | John | 2 | Peter | | 2 | Peter | 205 3 | Mary | 564 | 3 | Mary | When I attempted to merge the …

Regards