Column to Rows

[cherry]

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

[Sainath.Srinivasan]

Split into 3 seperate links and gather them together.

Use constant string for third column.