I have got a text file which needs to be organized in Excel.
The data goes something like this.
1. BoBoBo Ltd
Address: 5/F, Joseph Plaza , 14 Dodo Road, Hemisphere Bay, New South Conneticut
Contact: Mr.Harris Prouder, Group Chairman
What I want to do is put company name, address,phone,fax,e-mail,website and contact as headings. All the others go below their respective headings.
I have got more than a hundred entries like this and organizing them one-by-one is going to be very time consuming. I'd really appreciate any kind of help.
Thanks in advance