How to copy and paste in a loop in a set of 3 cells

[cubs786]

Hi,

I have an excel with lots of data but the data is in columns (each column has 10,000 or more data points), such as:

7.52
7.56
7.56
7.55
7.35

and I want copy the first three cells and transpose them on a different excel file, such as

7.52, 7.56, 7.56
7.56, 7.55, 7.35

But I want to do the whole column instead of manually copying and pasting three cells at a time.

I will be using a macro to do this job.

I know how to copy and paste the first three cells using macro but I want to continue all of the data to run in a loop to finish the job automatically or there is any other to do this?

thanks.

 

[kweaver]

You could do a variety of things: (1) use the macro; (2) format the range to not display 0s; (3) add an IF as you suggested.

=IF(0=INDEX($A:$A,ROW(A1)*3-3+COLUMN(A1)),"",INDEX($A:$A,ROW(A1)*3-3+COLUMN(A1)))

 

[DanteAmor]

column A

7.52
7.56
7.56
7.55
7.35

I want to have it in the same excel file

B C D
7.52, 7.56, 7.56
7.56, 7.55, 7.35
Hopefully it clears it up

Sorry, but I understood that you wanted it in a different file because of your comment:

and I want copy the first three cells and transpose them on a different excel file, such as

The macro is so that another book is created and also for several columns, due to your comment:

but the data is in columns

Of course, the macro will not work.