Identifying variances in a pivot table row

[TheRedCardinal]

Hi all,

I have a pivot table that looks like this:

Item setup validation report_08012022 - AX submission entities only.xlsx
	A	B	C	D	E
3	ItemId	DataAreaId	8 Digit Code	ItemName	Count of ItemId
4	000001	IL	39119099	STATSAFE 3000 in 15.9 kg (net) pail	1
5		VF	39119099	STATSAFE 3000 in 15.9 kg (net) pail	1
6		VG	39119099	STATSAFE 3000 in 15.9 kg (net) pail	1
7	000002	IL	39119099	STATSAFE™ 2500 in 15.9 kg (net) Pail	1
8		VG	39119099	STATSAFE™ 2500 in 15.9 kg (net) Pail	1
9	000033	IL	29012900	1-DECENE in Bulk	1
10	000080	IL		9000 HE ja1 in 8kg (net) pail	1
11		VF		9000 HE ja1 in 8kg (net) pail	1
12		VG		9000 HE ja1 in 8kg (net) pail	1
13	000094	IL	29215190	AO-22 in Bulk	1
14		VB	29215190	AO-22 in Bulk	1
15		VG	29215190	AO-22 in Bulk	1
16	000101	IL	38119000	AO-31 in 200kg (net) Drum	1
17		VE	38119000	AO-31 in 200kg (net) Drum	1
18		VF	38119000	AO-31 in 200kg (net) Drum	1
19		VG	38119000	AO-31 in 200kg (net) Drum	1
20	000102	IL	38119000	AO-32 in 900kg (net) IBC	1
21		VB	38119000	AO-32 in 900kg (net) IBC	1
22		VE	38119000	AO-32 in 900kg (net) IBC	1
23		VF	38119000	AO-32 in 900kg (net) IBC	1
24		VG	38119000	AO-32 in 900kg (net) IBC	1
25		VN	38119000	AO-32 in 900kg (net) IBC	1
pivot

What I need to do is determine whether for every single Item ID, whether there is any variance in the 8 digit codes that are listed.

For example, here is an item code that has two different 8 digit codes:

Item setup validation report_08012022 - AX submission entities only.xlsx
	A	B	C	D
80	000312	IL	32049000	Oil Blue A Powder in 24.95kg (net) drum
81		VF	32049000	Oil Blue A Powder in 24.95kg (net) drum
82		VG	38231300	Oil Blue A Powder in 24.95kg (net) drum
pivot

There are 6000 odd item codes so a method to do this automatically would be great.

There is no guarantee that the codes that match will be bunched together either.

Thanks!