ExcelBanter - copy and paste

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - copy and paste (https://www.excelbanter.com/excel-worksheet-functions/192469-copy-paste.html)

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.

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

On Jun 24, 8:16 pm, Igneshwara reddy
wrote:
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.