Help Help - Sorting Data

  • Thread starter Thread starter kotzab
  • Start date Start date
K

kotzab

I have a list that I am trying to sort but have received the informatio
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 outline
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 thank
 
One way ..

Assuming source data in A1 down ..

Put in B1: =INDEX($A:$A,ROW()*4-4+COLUMN()-1)
Copy B1 across to D1, fill down until zeros appear,
signalling exhaustion of data extracted from col A
(since you have 7ooo, copy down till around D1750)

Freeze cols B to D via an "in-place"
Copy > paste special > values > OK

Delete col A
 
Back
Top