transposing formulas

  • Thread starter Thread starter RAquino
  • Start date Start date
R

RAquino

DATA SET: A1="1", B1="2", C1="3"

DESIRED RESULT:
1
2
3


INITIAL FORMULA SYNTAX: E1="=A1"
EXPECTED RESULT: 1

OBJECTIVE: To copy the formula horizontally (E1,E2, E3) while
referring to horizontal data (A1, B1, C1).

PROBLEM: If I were to copy the E1 formula to E2 and E3 the formula
variables would also increment vertically (number increments) so that
the formula syntax would be E2="=A2" and E3="=A3". The net result for
E1, E2, and E3 would be 1, 0, and 0 respectively.


QUESTION: Is there a script/function/method that I can create a data
set vertically and write formulas horizontally (or vice versa)? I used
a really simple example so that you may easily duplicate this problem
but can send you the far more complex spreadsheet if necessary.

I know that the simple, and proper practice would be just align all my
formulas in the same orientation that my data set is. I have been
contracted to provide the data and calculations in a very specific way
so that is out of the question.

Appreciate all the help!
 
Back
Top