Is it possible to have a calculated column display data from one
column but use data from another?

I would like to have one single column that displays the name but when
clicked, uses the E-mail link to open our e-mail client and I would
like to accomplish it with minimal exertion.

Column 1 | Column 2
Name | E-Mail address (linked)

Combined Column
Name (that is an email link)

And if that can't be done, I'd like to know if there is some sort of
carriage return formula I could use in a Calculated column that would
display Column 2 right below Column 1 on one row:

Name
E-Mail