- Trending Categories
- Data Structure
- Operating System
- MS Excel
- C Programming
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Convert One Cell to Multiple Cells/Rows in Excel?
Have you faced a problem where all the data is present in a single cell and you are unable to perform any operations and need to divide the data into multiple cells? If you try to divide the data manually, then it can be a time-consuming process. Instead, you can use a simple trick mentioned in this tutorial to save time and get more accurate results. Read this tutorial to learn how you can convert one cell to multiple cells or rows in Excel.
Converting One Cell to Multiple Cells/Rows in Excel
Here, we will first use the Text to Column operation and then use the transpose while pasting the data. Let's look at a simple procedure for converting one cell to multiple cells or rows in Excel. We can complete this process directly in Excel by following some simple steps.
Consider an Excel sheet containing data that is similar to the data shown in the image below.
Now select the data, then click on data and select text for columns.
Select data > Data > Text to columns
Then select the delimited list and click next.
Delimited > Next
Deselect all of the check boxes and choose comma before clicking Finish.
Deselect > Comma > Finish
Then select the values and use the command CTRL + C to copy the values, click on an empty cell, then right-click and select Transpose Paste as shown in the below image.
Select data > CTRL + C > Empty cell > Right click > Paste
Our final result will be similar to the image shown below.
In this tutorial, we used a simple example to demonstrate how you can convert one cell to multiple cells in Excel.
Kickstart Your Career
Get certified by completing the courseGet Started