Transposing table and using header name as row name

[#1]

Need help turning this table below:

into this pivot (which I also would like to turn into a stack bar chart):

Any suggestions?

Thanks!

Carol

[sunny_talwar · Accepted solution]

Use CrossTable to transform your data in the backend and then use Pivot table on the front end to display your data in this way?

UPDATE: Sample attached