Text to Rows in Excel

There is an Excel tool that converts text to columns taking data from a single column and splitting it into multiple columns.

But you won’t find a similar tool that converts text to rows.

If you want to achieve this you have to do a trick.

Text to Columns Wizard

In order to convert text to rows, first, you need to convert text to columns.

Take a look at the following example.

Select data from A1 to A5 and choose DATA >> Data Tools >> Text to Columns.

A new window will appear.

In the first step choose Delimited and click Next.

In the second step in the Delimiters, choose Comma. Under the Data preview, you can see how your data will look like.

Converting columns to rows

Now, what you need to do it to select data from A1 to D5, copy it, and right-click in a place where you want the new data to be pasted.

But instead of using normal pasting use Transpose.

This is how your data will look after applying some formatting.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.