I suggest using ARRAY_AGG and OFFSET. It concatenates the different Function values while OFFSET(0) picks the first element of the array.

SELECT 
   Email, 
   ARRAY_AGG(Function)[OFFSET(0)] as Function
FROM database
GROUP BY Email