I have a database where a customer is listed say 5 times and each time he has
a different order # and service code. The multiple order#'s run vertical
down one column and service codes run vertical down another column and I need
to get each order # and each service code into it's own column.

Ex.

order# service code
123 abc
456 def
789 ghi

Needs to be:

order# order#2 order#3
123 456 789


etc.

Any ideas?

Thanks.