I have a list that I am trying to sort but have received the information
in one column - refer examlpe 1 below


EXAMPLE 1

Column A

1 Suburb
2 Name
3 Address
4
5 Suburb
6 Name
7 Address
8
9 Suburb
10 Name
11 Address
12
13 Suburb
14 Name
15 Address


Note every 4th cell is blank.

There are over 7,000 cells in the list.


I need to somehow sort the list into 3 separate columns as outlined
below:

EXAMPLE 2

Column A = Name
Column B = Address
Column C = Suburb


Is there any way this can be done?

Can anyone please urgently assist me as I have no idea?

Many thanks


--
kotzab
------------------------------------------------------------------------
kotzab's Profile: http://www.excelforum.com/member.php...o&userid=28353
View this thread: http://www.excelforum.com/showthread...hreadid=479357