Information générale
Catégorie:
Codage, syntaxe et commandes
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement