combining contents of one field

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

lets try that again! sorry

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
scenario into one field. So instead of having a list like

Scenario Measure
1 a
1 b
1 c
1 d
2 s
2 t
2 a

it reads

[Scenario] [Measures]
1 a, b, c, d
2 s, t, a

any help would be greatly appreciated.
thanks
 
Back
Top