compare two rows for multiple columns

[IMSL]

Hi all,

I have table with many rows and columns.

Every two rows have a unique ID (always applies).

How can I compare each two rows with identical ID to figure out any discrepancies in any of the columns?

Input
F1 (ID)	F2	F3	F4	F5	F6	…
001	a	b	c	d	e
001	a	B	c	d	e
002	f	g	h	i	j
002	f	g	H	i	j
003	k	l	m	n	o
003	K	l	M	N	o
…

Output
F1 (ID)	Changed_Field
001	F3
002	F4
003	F2
003	F4
003	F5

[CoG · Accepted solution]

Transpose Tool is the MVT (Most Valuable Tool) in this circumstance although there are some other preparations that are required (notice the filter that separates pairs of records into 2 separate data streams, that are joined for comparison):

Hope this helps and Happy Solving!

[nagakavyasri · Accepted solution]

@IMSL Another way:

[IMSL]

@CoG @nagakavyasri Thank you both for your nice solutions :)