Best way I can explain what I want is if I give an example, I guess.
Let's say I have a chart like this, where each clerk has to maintain an
updated and correct file on their clients. X indicates if there is an error,
and where the error is.

A B C D E F
G
1 Clerk ClientFirstname Error ClientLastName Error Address Error
2 Alvin Joshua X Smith 3 1st Ave.
3 Bert Jane X Smith 3 2nd Ave. X
3 Cathy George Tin 1 3rd Ave.

So in the above, Alvin has an error in his client's first name. Bert has an
error in his client's first name and address, and well, Cathy has no errors.

This is the end result I want:

Clerk FieldName FieldError
Alvin ClientFirstName Joshua
Bert ClientFirstName Jane
Bert Address 3 2nd Ave.

Basically a straightforward list listing everyone's error one at a time.
Formula-wise, is there an easy way to do this? I have to pass this sheet to
someone not so technically-savvy, so I want to keep it as simple as possible.

Thanks in advance for any help anyone can provide.