Hi, I have a data set of addresses numbers and each address number can have multiple usages such as bill to ship to etc.
My current report list each addresses number every time there is an individual usage. See below.
Number Use Code
709758 SHIP_TO
709757 SHIP_TO
709757 BILL_TO
709757 SOLD_TO
709756 SHIP_TO
709756 SOLD_TO
709755 BILL_TO
709708 BILL_TO
709708 STMTS
709696 MARKET
709696 SHIP_TO
What I am trying to do is transept each usage into a one cell in a column next to each address number (so the address number is only listed once). See below:
Number Use Code
709758 SHIP_TO
709757 SHIP_TO, SOLD_TO, BILL_TO
709756 SHIP_TO, SOLD_TO, BILL_TO
709755 BILL_TO
709751 SHIP_TO
709733 SHIP_TO
709730 SHIP_TO
709729 BILL_TO
709728 INSTALL_AT
709708 BILL_TO, STMTS
709706 BILL_TO, MARKET
Is this possible? See attached and thanks in advance!!
Bookmarks