Is there any way to keep the formulas referencing the original cells when
transposing a column to a row. It always seems to pick up the transposed row
reference, i.e. A1-G1 vs. the original column reference A1-A7.