Hi, I have a table named AcctDxList...
I want to convert this into this list...
AcctNo, Dx1, Dx2, Dx3
000123, A01, A02, B01
000124, A03, B03, C01
In other words, I want to get only the first three DxCode of each AcctNo and put them all in one row as the columns Dx1, Dx2, and Dx3.
How do I do this?
Thanks in advance for your much appreciated help!