Pivot Table is designed for numbers, not text.
The first row and column are text headers,
the rest should be numbers.
However, I wrote a program that translates
the 1's that you got into text.
The macro behind the "Translate" button,
is tailored for my layout and probably will not
work in a new spreadsheet without modifications.
http://www.freefilehosting.net/download/3c0b4