asimillc
asked on
How to transform vertical data to horizontal format
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?
Table1
VendorID PymtVendor
COM35 COM35P
COM35 COM35Q
COM35 COM35S
Desired Results
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.
Table1
VendorID PymtVendor
COM35 COM35P
COM35 COM35Q
COM35 COM35S
Desired Results
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.
ASKER
All data is contained within one table. Does this solution join to the same table ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the quick help!
This will sort by name so the first alphabetical will be 1, then 2..... pymtvendor .
Open in new window