Hi folks, have been having a problem all day trying to figure this out so any help would be great.

I am hoping to get a column from sheet1 to display as a row in sheet2 in excel. There are 651 records so dont want to do it one by one.

I am using "=INDEX(Sheet1!$A$2,1,1)" to get the first entry in and "=INDEX(Sheet1!$A$3,1,1)" to get the second. As soon as i try to drag the cell to the right it keeps giving me the same input over and over again.

Doing my head in.

Cheers
Greg