Email from different columns to One Column

[Blessy Clara]

I split a column of emails and the emails are spread across all columns in excel -
Is it possible to bring all the emails to a single column ?
Data Example is as given below

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 742"]
<tbody>[TR]
[TD="class: xl65, width: 742"]enquiries@oaic.gov.au || privacy@wexaustralia.com || merchants@wexaustralia.com || wollongong@pedders.com.au || sales@pedderswarrnambool.com.au || griffith@pedders.com.au || info@pedders.co.uk || kalgoorlie@tyrepower.com.au || tyrepropicton@hotmail.com || sales.tsm@live.com.au || tuggerah@pedders.com.au || trident@tridenttyres.com.au || admin@ayresauto.com.au || townsville@pedders.com.au || toowoomba@pedders.com.au || mai@psi-ind.com || tarenpoint@pedders.com.au || ashiknanabhai@gmail.com || peddersh@hotmail.com || supaservice@outlook.com || info@sunburyexhaust.com.au || tdstewart@westnet.com.au || spinnerstc@gmail.com || info@southsidemechanical.com.au || southmelbourne@pedders.com.au || slackscreek@pedders.com.au || cori@sheppartonservicecentre.com.au || salisbury@pedders.com.au || admin@rolysauto.com.au || rockhampton@pedders.com.au || admin@pedderswagga.com.au || ringwood@pedders.com.au || rayprescott@rayprescottauto.com.au || prospect@pedders.com.au || jborella@spin.net.au || colac@absauto.com.au || phillip@pedders.com.au || penrith@pedders.com.au || arobles@3pconnect.com || vrodriguez@mercotec.com.py || pakenham@pedders.com.au || osbornepark@pedders.com.au || enquiries@peddersorange.com.au || matnnatly@bigpond.com || info@nowra4wdoutdoor.com.au || sales@tjmnorthernrivers.com.au || newcastle@pedders.com.au || codieb@sasgroup.co.nz || mornington@pedders.com.au || moorooka@pedders.com.au || moorebank@pedders.com.au || moorabbin@pedders.com.au || gereltod@ule.mn || modbury@pedders.com.au || midland@pedders.com.au || sales@pedders.me || mckay.automotive.sale@gmail.com || mascot@pedders.com.au || maryborough@pedders.com.au || maroochydore@pedders.com.au || marion@pedders.com.au || mandurah@pedders.com.au || malaga@pedders.com.au || mackay@pedders.com.au || peddersmoe@dodo.com.au || lilydale@pedders.com.au || lawrences@northnet.com.au || lawnton@pedders.com.au || launceston@pedders.com.au || parts@lardnerautomotive.com.au || pedders@psimotossports.co.th || pedders@aneka-ind.com || manager@pedders.me || keswick@pedders.com.au || atul@exeter.co.ke || joyceauto@bigpond.com || joondalup@pedders.com.au || info@iroc.co.jp || import@asfir.co.il || ipswich@pedders.com.au || sales@pedders.co.id || admin@huntermech.com.au || hornsby@pedders.com.au || hopperscrossing@pedders.com.au || william@pedderschina.com || hobart@pedders.com.au || tyremasters@bigpond.com || heidelberg@pedders.com.au || sales@hedoffroad.com.au || albany@batteryworld.com.au || sales@hannafordtyre.com.au || irongum@bigpond.net.au || granville@pedders.com.au || gosford@pedders.com.au || gippslube@bigpond.com || geelong@pedders.com.au || geebung@pedders.com.au || filippiauto@ncable.com.au || frankston@pedders.com.au || pfmotors@bigpond.com || ferntreegully@pedders.com.au || enoggera@pedders.com.au || matt@echucaservicecentre.com || sales@ozparts.eu || admin@duffyautos.net.au || roadster@bigpond.net.au || dpedders@bigpond.net.au || darwin@pedders.com.au || darrenpanizza7@bigpond.com || eaton@dapcotyreandauto.com.au || sales@discountautoparts.com.au || australind@discountautoparts.com.au || dandenong@pedders.com.au || crossroadstyreservice@telstra.com || info@brakepoint.com.au || ****burn@pedders.com.au || info@pedderschina.com || carolinesprings@pedders.com.au || capalaba@pedders.com.au || cannington@pedders.com.au || campbelltown@pedders.com.au || campbellfield@pedders.com.au || cairns@pedders.com.au || caboolture@pedders.com.au || burwood@pedders.com.au || burleighheads@pedders.com.au || bundaberg@pedders.com.au || info@pedders.com.my || brownsplains@pedders.com.au || admin@broomemotors.com.au || brookvale@pedders.com.au || broadlandsauto@bigpond.com.au || admin@whyallatyres.com.au || naracoorte@tridenttyres.com.au || embridge@ozemail.com.au || mattboyd@bscbathurst.com.au || steve@startracafrica.co.za || booragoon@pedders.com.au || blacktown@pedders.com.au || beresfield@pedders.com.au || bendigo@pedders.com.au || belconnen@pedders.com.au || ballarat@pedders.com.au || manager@aiss.au || alicesprings@pedders.com.au || albury@pedders.com.au || abs4802@hotmail.com || social@pedders.com.au || info@nowmedia.com.au || george7313@gmail.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 742"]
<tbody>[TR]
[TD="class: xl65, width: 742"]eo@optometrywa.org.au || oa@industrylegalgroup.com.au || cxo.admin@optometry.org.au || medinfo@deakin.edu.au || askflinders@flinders.edu.au || optometry.enquiries@qut.edu.au || optom-info@unimelb.edu.au || optometry@unsw.edu.au || applications@optometry.org.au || r.michie@optometry.org.au || l.hessing@optometry.org.au || s.kilderry@optometry.org.au || j.megahan@optometry.org.au || h.carter@optometry.org.au || j.donald@optometry.org.au || r.riches@optometry.org.au || t.scarf@optometry.org.au || k.ianson@optometry.org.au || s.koh@optometry.org.au || a.kotsos@optometry.org.au || l.arundel@optometry.org.au || h.podbury@optometry.org.au || c.roubos@optometry.org.au || k.hart@optometry.org.au || s.davies@optometry.org.au || s.hanna@optometry.org.au || s.cappuccio@optometry.org.au || r.dolan-murphy@optometry.org.au || l.brodie@optometry.org.au || admin.tas@optometry.org.au || optometristsasn.tas@bigpond.com || n.ostrognay@optometry.org.au || admin@optometrywa.org.au || infoqld@optometry.org.au || office.vic@optometry.org.au || vision@oaansw.com.au || national@optometry.org.au || cpd@optometry.org.au || advantage@optometry.org.au || pharma@optometry.org.au || s.shaw@optometry.org.au || l.dawson@optometry.org.au || policy@optometry.org.au || j.karis@optometry.org.au || marketing@optometry.org.au[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thank you