I'm wondering if this is possible and if so, how:

Say I have 6 columns of information, all of it text (no numbers or equations). I have another column that I want to use to pull info from some of the other columns. Is it possible to automatically pull the info from the other columns so they appear in that 7th column in a desired format?

For example, I have text in the first three columns that look like this:
test1 | test2 | test3

Can I create some sort of function in column 7 that will format its self as:
| test2, test1 (test3) |

Is that possible?