Source table is in sheet: V, cols A across to D ... ,
col headers in row1, data from row2 down, viz

Cust# Visit01 Visit02 Visit03 ... Visit200
Cust001 Date01 Date03
Cust002 Date01
Cust003 Date03 Date04 Date05
Cust004 <blank 'no visits data as yet for this cust
Cust005 Date05
etc

In a new sheet,
I would like to make a simple 3 cols table (cols A to C)
from what's in V, ie:

Cust# Date Visit#
Cust001 Date01 1
Cust001 Date03 2
Cust002 Date01 1
Cust003 Date03 1
Cust003 Date04 2
Cust003 Date05 3
Cust004 <blank <blank
Cust005 Date05 1
etc

Appreciate your insights & help on a sub to achieve the above, guys. Thanks.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---