Have row items repeat which represent grouping in a Matrix table

[Sagejah9]

Hi , I am trying to build a table that looks like the below table. My dataset is unpivoted having the months in one column. I would use the Matrix visual to get the months as individual columns however the rows gets nested in each other forming hierarchy and I have to keep expanding the rows to see the other columns. How can I do this without using the regular table visual or pivoting my dataset

Dataset looks like this form:

StudentID	StudentName	Teacher	Subject	Month	Grade
1A2	John	Joe	Math	Jan	90%
1A2	John	Joe	Math	Feb	81%
1A2	John	Joe	Math	Mar	91%
1A2	John	Jessica	English	Jan	95%
1A2	John	Jessica	English	Feb	95%
1A2	John	Jessica	English	Mar	89%
2B2	Peter	Sparkle	Science	Jan	68%
2B2	Peter	Sparkle	Science	Feb	72%
2B2	Peter	Sparkle	Science	Mar	78%
5C2	Gary	Coby	Art	Jan	100%
5C2	Gary	Coby	Art	Feb	100%
5C2	Gary	Coby	Art	Mar	96%
5C2	Gary	Baugh	History	Jan	59%
5C2	Gary	Baugh	History	Feb	76%
5C2	Gary	Baugh	History	Mar	74%
5C2	Gary	Joe	Math	Jan	99%
5C2	Gary	Joe	Math	Feb	96%
5C2	Gary	Joe	Math	Mar	91%
10Y6	Kyle	Errol	Geography	Jan	88%
10Y6	Kyle	Errol	Geography	Feb	90%
10Y6	Kyle	Errol	Geography	Mar	97%

visualization I want to achieve

StudentID	StudentName	Subject	Teacher	Jan	Feb	Mar
1A2	John	Math	Joe	90%	81%	91%
1A2	John	English	Jessica	95%	95%	89%
2B2	Peter	Science	Sparkle	68%	72%	78%
5C2	Gary	Art	Coby	100%	100%	96%
5C2	Gary	History	Baugh	59%	76%	74%
5C2	Gary	Math	Joe	99%	96%	91%
10Y6	Kyle	Geography	Errol	88%	90%	97%

[TomMartens · Accepted solution]

Hey @Sagejah9 ,

transforming a matrix visual that looks like this:

with its nested row headers

into something that looks like this:

Mark the matrix visual and then change the formatting of the matrix visual:

1. turn off the "Stepped layout" and the "+/- icons"options
   
    
2.  turn off the "Row subtotals"
   

Hopefully, this is what you are looking for.

Regards,

Tom