Copying from one tab to another tab

[tycasey17]

Is there a way to have the A column in Sheet1 be copied onto Sheet2 but can the copied data have the =A1 to equal what is in Sheet1 instead of just copying the word in the cell?

Sheet1	Sheet2	=$A$1 (Apples)	=$A$2 (Oranges)	=$A$3 (Bananas)
(A1) Apples
(A2) Oranges
(A3) Bananas

 

[offthelip]

put this equation in Sheet2 A1 and copy it down and across. this will invert rows and columns as in your example

=OFFSET(Sheet1!$A$1,COLUMN(Sheet1!A1)-1,ROW(Sheet1!A1)-1)