Hi All,
I have the following requirement.
My Input data looks like:
SAP_CODE AIM_PART CRD_PART ACM_PART
1 M 1 2
2 F 2 1
3 U 3 3
My Output should look like:
SAP_CODE CODE PART
1 M AIM_PART
2 F AIM_PART
3 U AIM_PART
1 1 CRD_PART
2 2 CRD_PART
3 3 CRD_PART
1 2 ACM_PART
2 1 ACM_PART
3 3 ACM_PART
Any help is greatly appreciated.
Regards
Cherry
Column to Rows
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom