thanks for the replies.

erin,

the reason i need to avoid th pivot function is because i'm using an older version that doesn't have it.

howard,

the name of the columns should be the value in [stopid]

a sample output when line 2 is chosen would be:

line1234

258374041

thanks again!!