Hi - Hate to review an old thread after so long, but I need to do something similar. In Jeff Moden post on 8/19/2009 1:19:13 AM he uses a process that is great if you know what values are in the field (Apples, Oranges, Lemons), but what if you don't. What if you need to flatten something indeterminate like an Email field?