combining field contents to one field via a query

L

Lisa

I know this can be done but I cannot remember how to do
so.

My data is a [Scenario number] and mulitiple [measures] to
the Scenario. I want to roll all the measures for one
scenarion into one field. So instead of having a list like

Scenario Measure
1 a
1 b
1 c
1 d

it reads

Scenario
1
 
Top