![]() ![]() For example, if you currently have 4 columns and 10 rows, the converted table will have 10 columns and 4 rows. Select the first cell of the destination range.īe sure to select a cell that falls outside of the range containing your original data, so that the copy areas and paste areas do not overlap.Copy the selected cells either by right clicking the selection and choosing Copy from the context menu or by pressing Ctrl + C.all the cells with data in a spreadsheet, press Ctrl + Home and then Ctrl + Shift + End. To switch rows to columns, performs these steps: ![]() The country names are organized in columns, but the list of countries is too long, so we'd better change columns to rows for the table to fit within the screen: ![]() Suppose you have dataset similar to what you see in the upper part of the graphics below. Convert rows to columns in Excel using Paste Special ![]()
0 Comments
Leave a Reply. |