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.
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 |
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 |
Thank you so much, it works, is it possible to also pivot it to look like this?