How can I interchange rows to columns whole pasting in excel?

Answer 1

When pasting, use the right mouse button to click and then use the paste option that shows with two arrows joined at the base, one pointing right and the other pointing down.