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]
