thanks very much for reply and willingness to help.

i replied to the other thread. pivot table is not an option.

thanks.