I need to figure out how to automatically transform data and/or populate
cells. Some examples of the things I need to do:
-change all instances of "male" to "M" and all instances of "female" to "F"
-combine separate columns with street, city, state, zip, & country into one
column
-automatically populate a column asking whether work experience was paid or
voluntary based on the heading of the column next to it

I don't know if all of these things are possible but any help you could
offer would be greatly appreciated.

Thanks.