How can I pivot this data set with two layers?

[alteryxisconfusing]

I'm currently using cross tab, tables, and render tools in my workflow, but I can't figure out how to manipulate this data set into a pivot. 

Attached are the raw input file and below is an image of the desired output I am trying to achieve. 

 

[binuacs]

@alteryxisconfusing the same use case discussed in the below weekly challenge

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-292-It-s-about-Pivoting-Prepping-and-Rep...

[Felipe_Ribeir0]

Hi @alteryxisconfusing 

One way of doing this

[alteryxisconfusing]

Is it possible to have it displayed in the Output in this manner? I don't need the row/column totals like in the image, just the data grouped accordingly by student name and then showing their associated class cost and expense. So it should output kind of like this:

Student Name	Cost Type	Biology	Chemistry	History	Physics
Ashley
	(blank)			0.01
Frank
	Class Cost	866		705	963
	Expense			232	197
George
	Class Cost	579	681	983	933
	Expense			201	189

[alteryxisconfusing]

Is it possible to have it displayed in the Output in this manner? I don't need the row/column totals like in the image, just the data grouped accordingly by student name and then showing their associated class cost and expense. So it should output kind of like this:              

Student Name	Cost Type	Biology	Chemistry	History	Physics
Ashley
	(blank)			0.01
Frank
	Class Cost	866		705	963
	Expense			232	197
George
	Class Cost	579	681	983	933
	Expense			201	189

[Felipe_Ribeir0]

Hi @alteryxisconfusing 

Please take a look at the attached version.

[alteryxisconfusing]

Thank you so much, it works, is it possible to also pivot it to look like this?

[Felipe_Ribeir0]

Hi @alteryxisconfusing 

Please take a look at the attached version.