Sorry, a typo & a missing line corrected ..

Put in E2:
=OFFSET($D$2,ROW(A1)*5-5+COLUMN(A1)-1,)

Copy E2 across 5 cols to I5,

The last line above should read as:
Copy E2 across 5 cols to I2,

---
CName3 Contact3 Add3
etc

The above should read as
(for the sample data set given):

CName3 Contact3 Add3
CName5 Contact5 Add5
etc

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----