Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
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 Vector / Single Row or Column to Matrix in Excel?
A matrix is rectangular array with n rows and m columns. Sometimes in excel when we have a data in single column or single row you would want to convert them into a matrix. If you try to solve this manually, then it can be a time-consuming process, as we need to copy each row manually and paste them. So let us see a faster process.
We can solve this using the formulas supported by Excel. The only condition for the matrix is that the all the values must be filled in whole "m*n" values. This tutorial will help you to understand how we can convert vector or single column to matrix in Excel.
Converting a Single Column to Matrix in Excel
Here we will use the formula to get a single value and then fill all the values using the auto-fill handler. Let's look at a simple procedure for converting a single column to a matrix in Excel.
Step 1
Let us consider an Excel sheet where the data is a list of elements similar to the below image.
Then, in our case, cell C1, click on an empty cell and enter the formula as follows −
=OFFSET($A$1:$A$15,COLUMN()-COLUMN($C$1)+((ROW()-ROW($C$1))*(ROWS($A$1:$A$15)/3)),0,1,1)
and click Enter to get our first result. In the formula, A1:A15 is the range of our values, C1 is the address of our current cell, and 3 is the number of rows you want to create in the matrix.
Empty cell > Formula > Enter
Step 2
Now drag in both right and down directions using the auto-fill handle to create a matrix similar to the below image.
If we want to create a matrix based on a row, we can use the same process, but the only change is that the formula will be changed to
=OFFSET($A$1:$J$1,0,COLUMN()-COLUMN($C$2)+(ROW()-ROW($C$2))*(COLUMNS($A$1:$J$1)/5),1,1).
Conclusion
In this tutorial, we used a simple example to demonstrate how you can convert a single column to a matrix in Excel.
3K+ Views
