copy and paste

[Igneshwara reddy]

Hi,

I have set of data from B1:F1 rows and like this I have nearly 600 lines of
data, I need to copy all this data and paste into column A with the transpose
option. I This will be difficult if I want to repeat for 600 lines.

Is there anyway we can do with the formula.

Regards,
Igneshwara Reddy.

 

[vezerid]

Igneshwara,

it is not clear what you want to do. A 600x5 table will be transposed
to a 5x600 one. Apparently you want to put everything in a single
column. In this case in A1:

=INDEX($B$1:$F$600,INT((ROW()-ROW($A$1))/5)+1,MOD((ROW()-ROW($A$1)),
5)+1)

You can then copy the formula down to A3000

HTH
Kostis Vezerides