Change vertical data into horizintal table
 

I have data provided as a vertical set of information and need to able to
convert it to a table

ie
Name1
Address1
Tel No1
Name2
Address2
Tel No2

change to :-
Name1 Address1 Tel No 1
Name2 Address2 Tel No 2

Any ideas please?
--
Thanks in advance

Change vertical data into horizintal table
 

If you list contains only data, no labels
try this:

Col_A contains the list, beginning in A1

C1: =INDEX($A:$A,(ROWS($1:1)-1)*3+COLUMNS($C:C))

Copy C1 across through E1
Copy those formulas down as far as you need.

Using your example, these values are returned in C1:E2
Name1 Address1 Tel No1
Name2 Address2 Tel No2


Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Big Mac" wrote in message
...
I have data provided as a vertical set of information and need to able to
convert it to a table

ie
Name1
Address1
Tel No1
Name2
Address2
Tel No2

change to :-
Name1 Address1 Tel No 1
Name2 Address2 Tel No 2

Any ideas please?
--
Thanks in advance