Loop copy cell of range to 1 cell, and so on till cell empty

Hello friends, Hope all is well!

Please help me: I am trying to have a loop, that will:

a. Go through sheet “COLUMN”
b. Through ranges “R2” till there is no more data (empty cells in the R range)
c. And copy the contents of R current active cell and pastes it in X2, and so on.
This way X2 keeps changing till the loop end.
d. If the looped range / active cell equals NO, code go on to the next cell and so on

Thank you so much in advance!