Change vertical data into horizintal table

[Big Mac]

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?

 

[Ron Coderre]

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)