Transposing Columns (Crosstab, Union)

[mous]

Hi

I have a query that displays the following data.

Subject Weeks

Basic Skills 7-13
Basic Skills 15-21
Basic Skills 23-30
Basic Skills 32-53
Outdoor Skills 7-13
Outdoor Skills 15-21
Outdoor Skills 23-30
Outdoor Skills 32-53

I would like to create a query that creates only two rows, for example:

Basic Skills 7-13, 15-21, 23-30, 32-53
Outdoor Skills 7-13, 15-21, 23-30, 32-53

I looked in the forum but cannot see anything that I understand. Thanks for any assistance.