How do I transpose a column to a matrix in Excel

0 votes
I use a MacBook to work with Excel, and I have no idea how to convert, for instance, a column of 9 elements to a 3x3 matrix. The first column of the matrix will have the first element repeated three times, and so on, therefore my attempt at using the TRANSPOSE function did not produce the desired results.
2 days ago in Others by Kithuzzz
• 20,660 points
10 views

1 answer to this question.

0 votes

With data in column A, pick some cells and enter:

=INDEX($A:$A,COLUMNS($A:A)+3*(ROWS($1:1)-1),0)

Then copy both across and down.

enter image description here

I hope this helps you.

answered 2 days ago by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How do I protect all worksheet in an Excel workbook with a single click?

VBA Code : Dim ws as Worksheet Dim pwd ...READ MORE

answered Oct 22 in Others by narikkadan
• 37,660 points
29 views
0 votes
1 answer

How to use a named column in Excel formulas

Let's say I have the following figures ...READ MORE

answered Oct 24 in Others by narikkadan
• 37,660 points
38 views
0 votes
1 answer

How can I use a command button in excel to set the value of multiple cells in one click?

Try this: Private Scan As Integer Private Sub CommandButton1_Click() ...READ MORE

answered Oct 24 in Others by narikkadan
• 37,660 points
57 views
0 votes
1 answer

How do I set the default paste special in excel to paste only values

I paste the values with a keyboard ...READ MORE

answered Nov 6 in Others by narikkadan
• 37,660 points
46 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
101 views
0 votes
0 answers

What is the fastest way to transpose a matrix in C++?

I have a reasonably large matrix that I need to transpose.  Assume, for example, that my matrix is a b c d e f g h ...READ MORE

Jul 15 in C++ by Nicholas
• 7,120 points
101 views
0 votes
1 answer

Transpose column on one sheet to row on another, with linking

select A1:J1 in worksheet B and enter: =TRANSPOSE('worksheet ...READ MORE

answered Sep 25 in Others by narikkadan
• 37,660 points
48 views
0 votes
1 answer

Transposing columns to rows in Excel

Due to the amount of your data, ...READ MORE

answered Oct 1 in Others by narikkadan
• 37,660 points
62 views
0 votes
1 answer
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP