## How to convert matrix to vector or single column in Excel?

Have you ever tried to convert a matrix of cells to a single row or column in Excel? Maybe, you can copy a row or a column and paste them one by one to a single vector, but, this will be time-consuming if there are multiple rows and columns. In this article, I will talk about some interesting methods and hope them help you.

**Convert a matrix of cells to single row or column with formulas**

**Convert a matrix of cells to single row or column with Kutools for Excel**

** Convert a matrix of cells to single row or column with formulas**

The following formulas may help you to quickly convert the matrix to a single row or column. Please do as follows:

**Convert a matrix of cells to a single column**

**1**. First of all, you should define a range name for the matrix data. Select the range of cells and type a range name in the **Name box** which is next to the formula bar, and then press **Enter** key. In this case, I type “Matrix” as the defined name, see screenshot:

**2**. Then enter the following formulas:

(1.) Convert the matrix to single column based on row, it means the values are taken from each row, moving across then down: **=OFFSET(Matrix,TRUNC((ROW()-ROW($G$1))/COLUMNS(Matrix)),MOD(ROW()-ROW($G$1),COLUMNS(Matrix)),1,1)**(**Matrix** is the range name you defined in step 1, and **G1** is the cell you enter this formula). Then drag the fill handle to the cells till 0 is displayed, see screenshot:

(2.) Convert the matrix to single column based on column, it means the values are taken from columns, moving down one column and then across to the right column: **=OFFSET(Matrix,MOD(ROW()-ROW($G$1),ROWS(Matrix)),TRUNC((ROW()-ROW($G$1))/ROWS(Matrix)),1,1)** (**Matrix** is the range name you defined in step 1, and **G1** is the cell you enter this formula). Then drag the fill handle to the cells till 0 is displayed, see screenshot:

**Convert a matrix of cells to a single row**

To convert a matrix of cells to a single row, you can use the following formulas:

(1.) Convert the matrix to single row based on row, it means the values are taken from each row from left to right on one row and then moving down to the next row: **=OFFSET(Matrix,TRUNC((COLUMN()-COLUMN($A$7))/COLUMNS(Matrix)),MOD((COLUMN()-COLUMN($A$7)),COLUMNS(Matrix)),1,1)** (**Matrix** is the range name you created for your data range, and **A7** is the cell you enter this formula). Then drag the fill handle right to the cells till 0 is displayed, see screenshot:

(2.) Convert the matrix to single row based on column, it means the values are taken from each column, moving down one column and then across to the right column: **=OFFSET(Matrix,MOD((COLUMN()-COLUMN($A$7)),ROWS(Matrix)),TRUNC((COLUMN()-COLUMN($A$7))/(ROWS(Matrix))),1,1)** (**Matrix** is the range name you created for your data range, and** A7** is the cell you enter this formula). Then drag the fill handle right to the cells till 0 is displayed, see screenshot:

** Convert a matrix of cells to single row or column with Kutools for Excel**

If the above formulas are too long to remember, here, I can recommend an easy and powerful tool – **Kutools for Excel**, with its **Transform Range** utility, you can quickly convert multiple columns and rows to a single column or row as you need.

Kutools for Excel : with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. |

After installing **Kutools for Excel**, please do as following steps:

**1**. Select the matrix of cells that you want to convert.

**2**. Then click **Kutools** >** Range** > **Transform Range**, see screenshot:

**3**. In the **Transform Range** dialog, select **Range to single column** if you want to convert the matrix to a single column, or choose **Range to single row** if you want to convert matrix to a single row, see screenshot:

**4**. Then click **OK** button, and in the popped out **Transform Range** box, select a cell where you want to put the result, see screenshot:

**5**. And then click** OK** button, your select matrix of cells have been converted a single row or column.

**To know more about this Transform Range utility.**

** Download and free trial Kutools for Excel Now ! **

** Demo: Convert a matrix of cells to single row or column with Kutools for Excel**

**Kutools for Excel**: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.

**Download and free trial Now!**

### Best Office Productivity Tools

**Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. ** **Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...**

#### Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!