2009/9/7 Jonathan Kaye <[email protected]> > Hi all, > Here's the problem. I have a spreadsheet organised as Follows > A B C D ... > 1 Tom, Dick, Harry | z123 | blah blah | mxyz ... > > The vertical bar | represents the cell boundary. Note in column A the names > are separated by commas. What I need to do is split off each comma > separated > item in Column A and combining each item with the same values for Columns > B, > C, D, etc. > > So record 1 above should be expanded to this. > A B C D ... > 1 Tom | z123 | blah blah | mxyz ... > 2 Dick | z123 | blah blah | mxyz ... > 3 Harry | z123 | blah blah | mxyz ... > Any suggestions about how I could do this using a calc macro? > Thanks in advance for any advice. > Cheers, > Jonathan > -- > Registerd Linux user #445917 at http://counter.li.org/ > Please do not send me copies of list mail. I read the lists. Thanks! > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
Not using a Calc macro. If it were me I'd export the sheet as a CSV file, write a Perl script to generate a new [correctly formatted] CSV file and import that into a new sheet. I doubt a suitable Perl script would be more than about 10 lines of *un*obfuscated code. -- Harold Fuchs London, England Please reply *only* to [email protected]
