View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default I'd like to put multiple rows in one CSV row

Is the row "identifier" always of the format xxx-xxxx or could it contain more or fewer characters?

--
Tim Williams
Palo Alto, CA


wrote in message oups.com...
I've got a table that looks like this:
017-2032 24
017-2032 30
017-2032 49
017-2032 315
017-2095 30
017-2095 49
017-2095 24
017-2095 315
017-2096 24
017-2096 315
017-4246 315
017-4246 24
017-4246 30
017-4246 49
024-3308 305
024-3308 304

And I'd like to make it look like this:

017-2032 24,30,49,315
017-2095 30,49,24,315
017-2096 24,315
017-4246 315,24,30,49
024-3308 305,304


How can I do that? I'm really bad at this kind of stuff :(