Forum Discussion
matrix column transpose
I have a table like below
Name | Physics | Chemistry | Math | Class |
Akash | 87 | 78 | 90 | 10 |
Vikas | 88 | 80 | 96 | 10 |
Avinab | 89 | 89 | 98 | 11 |
Laxmi | 88 | 88 | 97 | 11 |
“Name” is a column so I tried it with Matrix visualization to change it in column and it worked but since I’ve columns as Physics, Chemistry, Math in database I’m stuck at changing these values to Row level
I want to transform this in below form:
| Name | Akash | Vikas | Avinab | Laxmi |
Physics | 87 | 88 | 89 | 88 | |
Chemistry | 78 | 80 | 89 | 88 | |
Math | 90 | 96 | 98 | 97 | |
Class | 10 | 10 | 11 | 11 |
When I’m trying pivoting it’s only taking one value suppose say its only pivoting first values as in like only class 10 values.
Can it be possible?
No Replies