I'm calculating an "complaint index" in one sheet where it ends up in a row and I want the values from that row to be copied to another sheet where they are meant to fill a column.



I can get single values via this:

='complaint index'!G9

but when I try to "drag it out" so that Excel realises that after G9 H9 I9 comes J9 it doesn't get it. I'm not keen on entering the letter for each field individually.

I hope you know what I mean and sorry for the basic question but it's driving me nuts and google didn't help me out...

Thanks!