Try this:

Assuming your data starts in Sheet1 in cell A1:

=INDEX(Sheet1!$A:$A,COLUMNS($A:A))

Copy across as needed.

--
Biff
Microsoft Excel MVP


"Darshan" wrote in message
...
I have the following data in sheet 1

Column A
1
2
3
4
5

I need to transpose the data of sheet 1 to sheet 2 but I need to retain
the
cell references so that whenever there is a change of data in sheet 1,
sheet
2 is automatically updated.

In sheet 2, i need to get the data like this

Column
A B C D E
1 2 3 4 5.


If any of u have an answer, please post the reply.