Hi, I would like to take a table of data (example below with four rows of responses) as such:
Model ; SN; Date ; Windows; Tires; Interior
Ford; 1234; 1/1/2011; Good ; Good; Fair
Ford; 1234; 1/1/2012; Good ; Poor; Poor
Chevy;9000; 1/3/2012; Fair ; Good; Fair
Toyota;5555;1/3/2012; Good; Poor; Good
and turn it to a crosstab type output that groups the responses of conditions to resemble the following:
............Windows; Tires; Interior
Good; 3; 2 ; 1
Fair ; 1 ; 0 ; 2
Poor ; 0 ; 2 ; 1
Please HELP!
Model ; SN; Date ; Windows; Tires; Interior
Ford; 1234; 1/1/2011; Good ; Good; Fair
Ford; 1234; 1/1/2012; Good ; Poor; Poor
Chevy;9000; 1/3/2012; Fair ; Good; Fair
Toyota;5555;1/3/2012; Good; Poor; Good
and turn it to a crosstab type output that groups the responses of conditions to resemble the following:
............Windows; Tires; Interior
Good; 3; 2 ; 1
Fair ; 1 ; 0 ; 2
Poor ; 0 ; 2 ; 1
Please HELP!
Last edited: