Hi
Here is my solution which works fine for me:
1. Highlight the first 3 columns with your mouse (to include each of the six smaller rows in column 3).
2. Then to pick up column four use Ctrl+Shift+Right Arrow. This will highlight column four also.
3. Enter Ctrl+C to copy.
4. Right click in column one where you want to paste the copied row.
5. Under Paste Options click on the third box.
You should find that your row will paste exactly as copied.
Good luck.
Tony