I have 22000 rows of data that are sorted into two columns. column a has 10
rows of address labels, a space, then repeated over and over again. i need to
sort this information into 10 columns but don't know how. can anybody help
with a formula that will enable me to have column headers of Name address etc
and the data filtered correctly

"current data"
Name 1st Move International Ltd
Add1 International House Worthy Road
Add2 Chittening Industrial Estate
Add3 Chittening
Add4 Bristol
PC BS11 0YB
Tel 0117-982-8123
Fax 0117-982-2229
Mail
web www.shipit.co.uk

I need it to be like this

A B and so on
Name Add1 and so on

Please help!!
--
James