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 :(
|