Question: how to copy multiple rows into multiple column in excel?
Answer: Convert rows to columns in Excel using Paste Special To quickly select the whole table, i.e. all the cells with data in a spreadsheet, press Ctrl + Home and then Ctrl + Shift + End. Copy the selected cells either by right clicking the selection and choosing Copy from the context menu or by pressing Ctrl + C.