View Single Post
  #1   Report Post  
swattoo swattoo is offline
Junior Member
 
Posts: 1
Default Data Sorting Technique

Dear All,
I have data in the following format (One Column With All the Data. Each Row Contains Different Data as mentioned below):
See Attachments for This

360-Lifestyle (Specialized)
P.O.Box71813
Tel04-3383310
LocationNext to BMW Show Room, Sh Zayed Road, Dubai
Send Enquiry
Abdul Majeed Bicycle
P.O.Box9586
Tel02-5542517
LocationM 6, Mussafah, Abu Dhabi
Send Enquiry
Abdulla Bilal Bilal Bicycle Trading
P.O.Box23978
Tel04-3497118
LocationAl Dhiyafa Road, Satwa, Dubai
Send Enquiry

and I need this data in below mentioned format (:

360-Lifestyle (Specialized) 71813 +9714-3383310 Next to BMW Show Room, Sh Zayed Road, Dubai Send Enquiry
Abdul Majeed Bicycle 9586 +9712-5542517 M 6, Mussafah, Abu Dhabi Send Enquiry
Abdulla Bilal Bilal Bicycle Trading 23978 +9714-3497118 Al Dhiyafa Road, Satwa, Dubai Send Enquiry
Attached Images