If you copy Cells having Formulas using cell references then these formulas when pasted change to reflect a new position.
If you just want the same values then use paste special which returns constants and text (CTRL +C >>ALT, E, S, V enter
You can also copy to the right by using the shortcut CTRL + R
However from your selection, I can tell that you have Hidden or Filtered Rows, which means you need to Copy and Paste ONLY Visible Rows. If this is the case then here is my 2 minutes tutorial on how to do that, watch it:
This is a Bite-Size Excel Tutorial Series (less than 3 minutes) targeting anyone on the globe using Excel since I broke the barrier of language and I explain the topic fully in graphics. In this tutorial I show you How to copy a range that includes Filtered or Hidden Rows and when pasting you only
For the numbers what I copied an entire column and special pasting it as values, without formula (which I think is what you suggested) However for the text, I did a regular copy and pasting since there were no formula, but as you can see, the copy and the pasted is a mismatch of value.