Copy and paste value X amount of times : I'm currently working on a project on VBA that requires multiple manipulation on data. 

I need to create a macro that copies the information from cell "Q2" and pastes it on cell "A2", "B2","C2" and "D2".
From there it needs to do the same with the information of cell "Q3" and paste it on "E2" and so on until there is no further data on "Q". 

At the moment it needs to paste the data a total of 4 times, but it needs to be modified later on for it to be 2 or 3 times. 

Any idea on how to make this?

Thanks! 