Data Tabulation - creating survey data tables

[MartinMarine]

We need to develop data tables where we cross tabulate survey data to produce a table with % values and a table with N values.

See the attached Excel workbook where I have Pivoted the Data to illustrate the desired output and provided examples.

The challenge is in creating one table that combines different questions on the x and y axis.

I have used IBM SPSS Custom Tables in the past to deliver the required outputs - http://www-03.ibm.com/software/products/en/spss-custom-tables

[MartinMarine · Accepted solution]

Solution offered by  Henriette Haigh | Client Services Representative Alteryx - attached.