![]() ![]() And the single column data has been converted into multiple rows as following screenshot shown:ģ. Then go on dragging the fill handle down to the range as far as you need. Meanwhile you must start this formula in the column C.Ģ. Note: A1 is the started cell, *5 stands for the number of cells that you want to have in each row. In a blank cell C1, please enter this formula: =OFFSET($A$1,COLUMNS($A1:A1)-1+(ROWS($1:1)-1)*5,0), and then drag the fill handle from C1 to G1, see screenshot: In excel, the OFFSET function can help you, you can use this formula as following steps:ġ. Transpose a single column to multiple columns with Kutools for ExcelĬonvert a single column to a range of data from row to row: Transpose a single column to multiple columns with formulas ![]() Here we will show you some tricky things about how to change a single column into multiple columns. Supposing you have a table as showing below, and you need to change one column to a range. How to transpose / convert a single column to multiple columns in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |