matrix column transpose

Anonymous — Wed, 01 Aug 2018 07:08:31 GMT

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?

topic matrix column transpose in Report Server

matrix column transpose