transpose w/ formula

hi everyone,

what i want to do is:
i want to display the contents of a row on a column, very much like transposing data but with a formula. can it be done?

cheers