As shown In the below images, the User Profile sheet consists in total of 112 rows, in which 111th and 112th rows consists of two emails. On the other hand in the Employee dashboard sheet both the emails from the User Profile sheet appears in 111th and 112th rows, but the 113 row shows duplicate email of 112th row which is wrong as there are no 113th row in the User Profile sheet.
FYI: I have used single value feature to extract emails from User Profile sheet to the Employee Dashboard sheet.
That’s odd, I can’t explain that.
Which row in your user profiles table does that extra one (...@gmail.com) correspond to? The first row, maybe?
@Darren_Murphy No to the last now which doesn’t exists. i.e 113th
That email value must be coming from somewhere. Are you saying that email address doesn’t exist in your User Profiles table? But you said it was a duplicate…
Yes that email is the duplicate of the upper row one, I had intentionally hidden it for confidential reasons.
So it comes from the very first row?
Is this a Pages project, or an App?
I’m asking lots of questions, because I can’t explain what’s happening, and so I’m searching for clues.
What do you mean by the first row ? The first row of every sheet on our project consists of different email id than this one,
It is an App project.
No worries
This is different from your very first screen shot - have you changed the data in your User Profiles sheet?
Anyway, it makes more sense now. But still, I can’t explain it. I tried to replicate it, and what happened when I tried - and what I would expect - is an empty value in that last row (Index 113).
Maybe @Jeff_Hager might be able to spot something here that I’m not.
No I haven’t, i have just changed the email content for confidential reasons to some xyz.com, except that no change in row or else. One thing you should notice is that even though I have changed the 112th row email for confidential reasons, the lower i.e. 113th row email shows the real email.
Yeah, I get it. But I can’t explain it. Have you tried refreshing the data editor (reloading the browser)?
It could be something as simple as the Data Editor being out of sync with the Glide back end. If that’s the case, reloading should resolve that.
Have tried multiple times but nothing happened 
Any chance it’s related to this? There have been some visual glitches in the data editor in the past week.
