I need so much help.
I have a table that has several columns with data. I would like to create a pivot table that counts how many cases of each category I have segregated by sex.
The original table is as follows
Sex Grade Age height
M......1.....<10..<4
M......1.....>10..>4
F.......2.....>10..>4
I want to generate a pivot table as follows
........................M.........F
count of Grade
1
2
count of Age
<10
>10
Count of Height
<4
>4
Any help is very much appreciated
Thanks
I have a table that has several columns with data. I would like to create a pivot table that counts how many cases of each category I have segregated by sex.
The original table is as follows
Sex Grade Age height
M......1.....<10..<4
M......1.....>10..>4
F.......2.....>10..>4
I want to generate a pivot table as follows
........................M.........F
count of Grade
1
2
count of Age
<10
>10
Count of Height
<4
>4
Any help is very much appreciated
Thanks