Excel formulas

[Guest]

NEED HELP...I have a formula set up to where it pulls data from a linked
sheet, I want to be able to click on the right bottom corner of where I have
the formula and drag it to populate accordingly to other rows...this works
but instead of pulling the information vertically which is what I need it is
pulling the info horizontaly from my linked sheet...how can I change the
orientation of where it pulls the info...i am dragging horizontal but want
the info from the other sheet to propogate using the vertical info
order....hope I made sense...anyone that can help me?...I would really
appreciatte it....I am working on deadline with this and can't figure it out.
THX ALLOT!

 

[Guest]

Use the transpose function. highlight verticle range where you want the
results top to bottom with the same number of rows as the source data has
columns, so that the top cell is the selected cell. type formula
=transpose($a$1:$z$1) in that first selected cell (meanwhile your range is
still selected), since this is an array, you need to use ctrl shift enter
instead of just enter

hth,
Dave