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!ġ. Kutools for Excel- Includes more than 300 handy tools for Excel. ![]() ![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |