Hay @angelak and welcome to the community.

Let me try and help you. Changing the data from rows to columns or columns to rows is known as transposing

If you copy the data, select where you want to paste the data, then right-click and under paste option, select transpose. This will work from one workbook to another.
The fastest way to do this is to learn the keyboard shortcuts.
Ctrl + C to copy
Ctrl + Alt + V to open paste special
E to select transpose
Enter to paste the transposed data

You could also use the function = TRANSPOSE(array), however, you mentioned that you copy to a different workbook and this could lead to linked workbooks which I don't think you want.

There is also an option to do it with Power Query. let me know if you want me to detail the steps involved using Power Query.

If this solves your problem , can you please add Solved to the title and upvote the comment