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.