Kutools for Excel’s Transform Range utility also supports to copy multiple rows horizontally and then paste as one column vertically, or copy multiple columns vertically and then paste as one row horizontally.
#EXCEL FOR MAC PASTE LINKS ACROSS ROW FULL#
Full feature free trial 30-day, no credit card required! Get It NowĬopy multiple rows horizontally and paste as one column vertically or vice versa Kutools for Excel- Includes more than 300 handy tools for Excel. Note: For copying a column vertically and pasting as one or multiple rows horizontally, please do as below screenshot shown: Now the row is copied horizontally and pasted as several columns vertically. Please specify the first cell of destination range, and click the OK button. And now another Transform Range dialog box comes out. (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.ģ.
(1) Check the Single row to range option in the Transform type section In the opening Transform Range dialog box, please (see above screenshot): Select the row you will copy horizontally, and click Kutools > Range > T ransform Range. Full feature free trial 30-day, no credit card required! Free Trial Now!ġ. In this condition, you can try Kutools for Excel’s Transform Range utility. Sometimes, you may want to copy a row horizontally and paste as several columns vertically in Excel.
0 kommentar(er)
