Okay got it, that makes sense. I am also having trouble with the Merged column again in this table:
I essentially want to have my "Merged Clay First Line" column to have the responses from the "College First Line Text Response" column and "Over 1 Year Opening Line Text Response" column if that makes sense. However, it's not pulling it correctly because the "Over 1 Year Opening Line Text Response" column has errors in it which I'm not sure why. Can you take a look again? Thank you!