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

Hi
you can use the TRANSPOSE function to that effect
Also review the INDEX syntax

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi Pecoflyer,

thanks for the quick reply, I have done that but the names may be changing and there are 650 of them and I am actually setting this up for someone else who would not have the best of excel knowledge(even less than me if thats possible ) so I would like to have them linked from one sheet to the other. The only way I can see it being done at the moment is manually and as I said I would prefer not to have to do that manually.

Thanks

Hi again Pecoflyer,

Finally got it, thanks for the suggestions as even searching under what you suggested helped. Think I had been at it so long my brain was melted.

=INDEX(Sheet1!$A2:A651,COLUMNS(Sheet2!$B1:B1),ROWS (Sheet2!$B$1:B1))

used that code and it works perfectly.