The PivotTable changes to mirror the new relationship. Though the PivotTable doesn’t seem proper quite nonetheless, as a result of ordering of fields from the ROWS location.Searches a range or an array and returns an item corresponding to the first match it finds. If a match does not exist,