![]() ![]() ![]() ![]() 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 |