copy and paste

I

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.
 
V

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top