How to create a reconciliation for 2 files, 1 vertical, 1 horizontal

[Isha_Gupta]

Hi,

I have 2 files with many columns in each.

Both files have a common identifier.

In 1 file, for each identifier, every data is in horizontal way. Like, city, country, name, XYZ ID 1, XYZ % 1, XYZ ID 2, XYZ % 2 and so on...

In another file, for XYZ 1 and 2, it is in vertical.

Each ID will have 2 rows, 1 with same other columns like city, country, name but xyz 1 and the other row with again same other columns but xyz 2.

I want to reconcile xyz 1s, 2s in both files for each ID.

Any way to do?

[Raj]

@Isha_Gupta Add some sample data will help with Workflow. Also add expected output.