Matrix from a 3-entry table
Solved
Hello everyone,
Not seeing the solution to a previously posted problem, I would like to bring this topic back up.
I am using Excel 2007 and I have a table consisting of 3 columns (column A, column B, column C).
I wish to transform this table into a matrix, such that:
- the rows are made up of the unique values from column A
- the columns are made up of the unique values from column B
- the body of the matrix is made up of the values from column C.
I would like the solution to be, if possible, without using macros.
Could you help me?
Excelently yours.
Configuration: Windows 7 / Safari 537.1
Not seeing the solution to a previously posted problem, I would like to bring this topic back up.
I am using Excel 2007 and I have a table consisting of 3 columns (column A, column B, column C).
I wish to transform this table into a matrix, such that:
- the rows are made up of the unique values from column A
- the columns are made up of the unique values from column B
- the body of the matrix is made up of the values from column C.
I would like the solution to be, if possible, without using macros.
Could you help me?
Excelently yours.
Configuration: Windows 7 / Safari 537.1
2 answers
-
ContributorGood evening,
An example by formula:
https://www.cjoint.com/?BHuxCyTQyDa
The X, Y must be sorted as in the example.
eric
--
You will never reply to an unsolicited DM...
Well, that's done. -
Thank you very much, Eriic, for your reply. I just found another solution using the "SUMPRODUCT" function. I'm sharing it with you for your information.
http://cjoint.com/data/0HvjPIMXP95.htm
