Transposing Row Data To A Column of Cells

Sorry 'bout the second post. Was trying to simplify my original writing and didn't realize it had already posted...first time here.

Next question, the steps provided work great when only raw data is being transposed, but when I tried transposing a row of cells containing summation formulae, I ended up with a column full of #REF! messages.

Is there a way to transpose a row containing formulae to a column as well?

Thanks again...the reference to the website discussing absolute formulas was a big help.