[Skunkworks] Excel question !Ngumu

Thuo Wilson lixton at gmail.com
Mon Jul 15 10:43:56 EAT 2013


On 14 July 2013 19:26, Philip Musyoki <pmusyoki at gmail.com> wrote:

> Wilson,
>
> I know this is late, but if still looking for a solution, I had sometime
> to kill and I have made you a Macro!
>
> You can modify and change the workings. Basic VBA. Sorry no comments! I
> hate doing that.
>
>
>
Hehe,

I have tried macro way in libre office and no luck!

I will check the madirisha office and update.

WIlson.



> On Wed, Jul 10, 2013 at 9:12 PM, Thuo Wilson <lixton at gmail.com> wrote:
>
>> Hey,
>>
>> Supposing i had an excel document like the attached with a thousands rows
>> and within a cell are multiple values separated by commas i want to spread
>> to other rows. How do i do it?
>>
>> See example; How do i spread column 3 so that each item/valu appear on
>> its own row. Mind you i have a thousands row with 3rd column with values in
>> excess of 100, so manual is attainable but tiresome.
>>
>>    Angola Mobile 2449  Anguilla Fixed 1264  Anguilla Mobile 126453,
>> 126458, 126472, 126477, 1264235, 1264469, 1264476  Antigua & Barbuda
>> Fixed 1268  Antigua & Barbuda Mobile 126872, 126873, 126876, 126877,
>> 126878, 1268464, 1268764  Argentina Fixed 54  Argentina Mobile 549
>> Armenia Fixed 374  Armenia Mobile 3744, 3745, 3747, 3749, 37460  Aruba
>> Fixed 297  Aruba Mobile 2975, 2976, 2979, 29756, 29758, 29759, 29773,
>> 29774, 29796, 29799...  Ascension Island Fixed 247  Australia Fixed 61,
>> 6128, 6129, 6138, 6139, 6173, 6186, 6187, 61261, 61262  Australia Mobile 614,
>> 6115, 6116, 6117, 6118, 6119  Australia Tollfree 611800  Australia Tollfree
>> (Series 611300) 611300
>>
>>
>> _______________________________________________
>> skunkworks mailing list
>> skunkworks at lists.my.co.ke
>> ------------
>> List info, subscribe/unsubscribe
>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
>> ------------
>>
>> Skunkworks Rules
>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
>> ------------
>> Other services @ http://my.co.ke
>>
>
>
> _______________________________________________
> skunkworks mailing list
> skunkworks at lists.my.co.ke
> ------------
> List info, subscribe/unsubscribe
> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
> ------------
>
> Skunkworks Rules
> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
> ------------
> Other services @ http://my.co.ke
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.my.co.ke/pipermail/skunkworks/attachments/20130715/c9d31976/attachment.html>


More information about the skunkworks mailing list