Queries :: Query To Cross-tabulate Data

I asked 18 people to each sort 100 statements into piles based on the similarity of the statements. The results are arranged as below.For example:

- Bob sorted statements 1, 3, and 100 into the same pile (Pile ID = 5), and statements 2 and 4 into the same pile (Pile ID = 2).
- Mary sorted statements 1 and 100 into the same pile (Pile ID = 3).

Code:
SubjectID StatementID PileID
------------------------------
Bob 1 5
Bob 2 2
Bob 3 5
Bob 4 2

[code]....

I need to create separate summaries for each Subject. The summary should indicate, for every possible pair of statements (1 & 1, 1 & 2, 1 & 3 ... 100 & 100), a 1 if the person sorted both statements into the same pile and a 0 if they didn't. Identical statement pairs (e.g., 1 & 1) should always get 1.

Code:
StatementIndex1 StatementIndex2 Similarity
1 1 1 (identical statements always get a 1)
1 2 0 (Bob did not sort statements 1 & 2 into the same pile)
1 3 1 (Bob sorted 1 & 3 into the same pile)
1 4 0 (Bob did not sort 1 & 4 into the same pile)

[code]....

I'm assuming a crosstab query is a start, but I couldn't figure out how to set it up.