Say you have a column of text: Dairy Meat Beverages Produce That you want to change into a row, like so: Dairy Meat Beverages Produce Or maybe you have a row of data that you want to change into a column. Moving the data manually, one item at a time, would be a tedious process. To save time, you can use the Paste Special command to quickly transpose a column of data to a row of data, or vice versa. Move data between rows and columns Copy the data in one or more columns or rows. Before you paste the copied data, right-click your first destination cell (the first cell of the row or column into which you want to paste your data), and then click Paste Special. In the Paste Special dialog box, select Transpose, and then click OK. You'll find theTranspose check box in the lower-right corner of the dialog box: Starting with your first cell, Excel pastes the data into a row or column. Columns and rows can not overlap. For example, if you select values in Column C, and try to...
Comments
Post a Comment