Column to Rows
Posted: Wed May 12, 2010 4:19 am
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
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