And here's another solution on a different slice axis.. I am sure ruby and perl folks can shell out a one liner
https://gist.github.com/anonymous/5978401

On Thu, Jul 11, 2013 at 1:53 PM, Benjamin <anangwe@gmail.com> wrote:
Well you can use many of the same to archive your goal , whats amazing is that all of us have different ideas.

Its like , being taught on how to slice through an orange either vertically or horizontally
all in all you still eat it.


On Thu, Jul 11, 2013 at 12:45 PM, Richard Gathogo <muraguri2005@gmail.com> wrote:
You can try Apache Poi.
Regards,

Richard Gathogo.


On Thu, Jul 11, 2013 at 12:26 PM, Isaac Kiplagat <isaac.kiplagat@gmail.com> wrote:
Save as either txt or CSV and by making use of " and , use PHP or another good programming language to manipulate into another CSV or txt and convert back to excel :)


On 11 July 2013 11:47, Thuo Wilson <lixton@gmail.com> wrote:


On 11 July 2013 07:31, Alex Mwega <slylex@gmail.com> wrote:
This is actually quite simple, just copy that column into a notepad, save as csv, open in excel and voila! copy the values back as individual columns. Hii mambo yote ya Macro is not necessary....



inakaa watu wengi hapa walianguka mtihani juu ya kutosikiza ama kutosoma sentensi kwa maakini. Am interested in rows not column - Column is easy.

Nitajaribu Tai alivyosema.

Wilson.
 
On Wed, Jul 10, 2013 at 10:54 PM, OpenCastLabs Consulting <dkipkulei@gmail.com> wrote:
Thuo,
I deal with these all the time. Send me the file I crack it in a min.

David Kandie
OpenCastLabs Consulting
Advanced Excel Training in Eastern Africa & DR Congo

-------------------------------------------------------
Budgeting, Forecasting & Financial Modeling Training - www.opencastlabs.com


On Wed, Jul 10, 2013 at 5:12 PM, Thuo Wilson <lixton@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@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@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@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@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



--
Isaac Kiplagat. KIP®



_______________________________________________
skunkworks mailing list
skunkworks@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@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@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