Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
Grouping data for excel spreadsheet
Is there anyway to group data before sending to an excel spreadsheet. Below is an example of the data and the format that I am trying to send to excel.
.dbf(all fields and variables are characters):
case v3 v4
a 105
a 105
b 225
b 225
excel(this would be the format I want to get):
case v3 v4
a 105 105
b 225 225
But this is what I get in excel instead:
case v3 v4
a 105
a 105
b 225
b 225
Anyone have any ideas? I have played around with the Select command and have not been successful.
Thanks,
Kimberly
Hope you will able to understand this because when I preview this it changes my format.
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