HI all,
i have problem. I have two files that i need to compare. Both files have same data in common but this informations are in a differents position (rows). How can i compare this data if i want to find all the common data "in the file but not in the same position". For example.
File 1
Row Data
1 A
2 B
3 C
File 2
Row Data
1 B
2 A
3 Z
Output
A , B
i have problem. I have two files that i need to compare. Both files have same data in common but this informations are in a differents position (rows). How can i compare this data if i want to find all the common data "in the file but not in the same position". For example.
File 1
Row Data
1 A
2 B
3 C
File 2
Row Data
1 B
2 A
3 Z
Output
A , B
Comment