I am trying transform vertical data into a single record horizontal layout. I have tried a number of ways including pivot, crosstabs, etc. Can anyone provide assstance?
VendorID PymtVendor1 PymtVendor2 PymtVendor3
COM35 COM35P COM35Q COM35S
Please note there could be up to 10 Payment vendors per vendor ID.
Thank you in advance.