Trying to input data from columns in cell

gregjordan38 · #1 07-30-2013, 08:48 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to input the text of a cell into another cell automatically ？	Juliet	Excel	1	03-15-2013 03:25 AM
how to input data vertically in spreadsheet?	mikehende	Excel	3	10-10-2012 11:40 PM
how to write G1 in terms of B1+value in the cell 5 columns away (which is G1 itself))	Sunny	Excel	3	04-20-2012 12:32 AM
Data input in Powerpoint?	DeeDubb	PowerPoint	1	04-05-2012 01:53 AM
Move data from 1 cell to another cell	Catalin.B	Excel	1	06-25-2011 12:51 PM