I am wondering how to approach my next task. I was hoping this could be done in a query but I do not think that it would be possible. I am needing to combine the data for each char1 group into one variable. Putting the Num1 for char1 "A" into variable with all of the num1 values 10,20,30. Here is example below with example data. Any help is appreciated. Thanks in advance.

Example Data:

char1 num1 num2 num3 num4
A 10 20 30 40
A 20 30 40 50
A 30 40 50 60
B 10 20 30 40
B 40 30 20 10

Want output to look like:

Char1 num1 num2 num3 num4
A 10,20,30 20,30,40 30,40,50 40,50,60
B 10,40 20,30 30,20 40,10


Hope this make sense.

Kimberly