We can apply Excel’s (Paste) Transpose feature to copy a row horizontally and then paste as a column vertically or vice versa in Excel. Select the row you will copy horizontally, right click and select the Copy from the right-clicking menu. See screenshot: 2. Select the first cell of destination column, right click and select the Transpose (T) in the Paste Options section of the right-clicking menu. Best Answer: You can use copy and paste special. Select the horizontal line of cells and copy (CTRL + C / Edit>Copy) Then select the cell you want the vertical list to start right click and paste special (edit > paste special). Tick the Transpose option at the bottom and click ok. Transpose feature in Excel 2013 is one of the main highlights of the Excel 2013 app. It converts horizontal row data sheets into the vertical column style sheets and back. See below screenshot: And now the row is copied horizontally and pasted as one column vertically. This (Paste) Transpose feature also supports to copy a column vertically and paste as one row horizontally, too. Copy a row horizontally and paste as one or multiple columns vertically or vice versa. Select the row you will copy horizontally, and click Kutools > Range > T ransform Range. See below screenshot: 2. In the opening Transform Range dialog box, please (see above screenshot): (1) Check the Single row to range option in the Transform type section; (2) Check the Fixed value option in the Columns per record section, and type the number of columns you will paste as into the right box. (3) Click the Ok button. And now another Transform Range dialog box comes out. Please specify the first cell of destination range, and click the OK button. Now the row is copied horizontally and pasted as several columns vertically. See below screenshot: Note: For copying a column vertically and pasting as one or multiple rows horizontally, please do as below screenshot shown: Copy multiple rows horizontally and paste as one column vertically or vice versa. Here I will take copying multiple rows and pasting as one column for example. Select the rows you will copy horizontally, and click Kutools > Range > Transform Range. Pc games available for mac. In the opening Transform Range dialog box, check the Range to single column option, and click the Ok button. And now the specified rows are copied horizontally and pasted as one column vertically. See above screenshot: Note: For copying multiple columns vertically and pasting as one row horizontally, please use the Range to single row option in the Transform Range dialog box. Demo: copy horizontal paste vertical or vice versa in Excel. ![]() ![]() Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day! 300 New Features for Excel, Make Excel Much Easy and Powerful: • Merge Cell/Rows/Columns without Losing Data. • Combine and Consolidate Multiple Sheets and Workbooks. • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion. • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter, • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools.
0 Comments
Leave a Reply. |