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
----
|