Note: If you want to convert the single cell values to multiple rows, you just need to convert it to multiple columns first, then select the column values and press Ctrl + C to copy them, then select a cell and right click to select Paste Special > Transpose. Click Finish, then the single cell has been converted to multiple columns, and then resize the columns. ![]() In the popping dialog, check Delimited option firstly, click Next to go the step 2 of the dialog, and check Space option under Delimiters section. Select the cell you need to convert, and click Data > Text to columns. In Excel, you only can convert a single cell to multiple columns or rows.ġ. ![]() Here I introduce two methods may help you quickly solve this task.Ĭonvert a cell row to multiple columns or rows with Text to Columns and Paste Transpose functionsĬonvert a single row to multiple columns and rows with Transform Range Suppose you have a row with a large data, and now you want to convert this single row to a range with multiple columns and rows as below screenshot shown, how can you solve it in Excel? How to convert a single row to multiple columns and rows in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |