Dear all,

I have some trouble with an Excel macro. I could find the command to get data from one sheet (sheet 1) to paste them to another one (sheet 2) to do so cell by cell. Now, I would like to write a loop to make it automatic on all the data of my sheet 1 (which are all in one single column) so that all these data are put into my sheet 2 but in one single row and only in one out of three cells. Here attached is a simple example of what I want to do with this macro.

If someone can help me with an example it would be very nice of you.

Cheers,

Max