Transpose a single column or row to ranges in Excel 2007 and 2010

The utility Transform Ranges in Kutools for Excel can help you transform a vertical column into several columns, or change a row to several rows quickly.

1. Tranform/change a column to multiple columns. Demo
2. Transform/change a row to multiple rows.

For example, if you have a column of data as shown in Fig.1, each customer’s information takes up 3 rows from up to down as name, Telephone and address, and vice verse.

Fig. 1

With Transform Vertical Range you can quickly convert that into three rows, like so: Demo

Usage:

1. Before using Transform Vertical Range, select the data to be transformed. It must be in a single column.

2. Click Kutools >> Modify >> Transform Vertical Range. See screenshots (Fig.2 and Fig.3).

Fig.2 Transform Range		Fig.3 Dialog box of Transform  Range

3.In the Transform Vertical Range dialog box, firstly verify the Data to be transformed inputting box contains the data you want to convert. Or click the button to reselect a column of data. See screenshot (Fig.3).

4. Select a cell as the output range. The output range can be in the same worksheet, other worksheets, or in other workbooks. See screenshot (Fig.3).

5. Specify the Rows per record option. If you choose the Blank cell delimits records, then the records will be delimited by a blank cell. If the records are not delimited by a blank cell, use the spinner to specify the number of rows per record as displayed in the Rows per record option. See screenshot (Fig.3).

6.Click OK.

Notes:

This function supports Undo (Ctrl + Z).

The data to be transformed keeps intact after transforming the vertical range.

The Data to be transformed range and the Output range can be in different worksheets or workbooks.

See Transform Vertical Range demo (video 1)

This is only one feature of Kutools for Excel

It includes more than 100 functions and tools for Excel 2007 and 2010.