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
--
Walter Nyamweya
_______________________________________________
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