Please add example source data and desired output.

• "For Email" should be a list of columns to replace. In the source, we have Email1, Email2, so instead, it can be FOR (email1, email2)
• count the same probably needed is count(awUniqueID)
• Is 1 and 2 values in Email1 and Email2? If not, another solution is necessary, but it is hard to help without an example