Hi

In cell B1 enter
=INDEX($A$1:$A$1000,COLUMN(A:A)+(ROW(1:1)-1)*4)
Copy across through C1:D1 then copy B1:D1 down until you see the first
row of 0's appearing.

Change the range $A$1:$A$1000 to encompass the full range of your
existing data.

--
Regards

Roger Govier


"Wibs" wrote in
message ...

Hi,

I have a table that consists of just one column, and consists of data
of the sort:

Forename
Surname
Telephone
<space
Forename
Surname
Telephone
<space

What I would like is three column headings, with the data under them,
i.e
Forename Surname Telephone
Fred Smith 01243-78935
John Brown 01229-321546

Is there an easy way to accomplish this?

Wibs


--
Wibs
------------------------------------------------------------------------
Wibs's Profile:
http://www.excelforum.com/member.php...o&userid=28922
View this thread:
http://www.excelforum.com/showthread...hreadid=551982