HI ,
I have searched thru the columns and found columns to rows conversion , but not the other way.
I have a table that has following value

id rank number
1 A 1001
1 B 1002
1 C 1003
2 A 1004
2 B 1005

I need to convert it to

id rank 'A' rank 'B'
1 1001 1004
2 1002 1005


Does anyone have any suggestions. I tried using define but could not eliminate extra rows that come with for example rank C.

Wouldn't

TABLE FILE ...
SUM NUMBER
BY ID
ACROSS RANK
END

do the job?

NO,
I need to be able to identify the across column.
its part of a bigger problem.

Here is my code
JOIN LIKP_VBELN IN LIKP TO MULTIPLE LIPS_VBELN IN LIPS AS J0
JOIN LIPS_VBELN IN LIKP TO VBUK_VBELN IN VBUK AS J1
JOIN LIPS_VGBEL IN LIKP TO VBAK_VBELN IN VBAK AS J2
JOIN VBAK_VBELN IN LIKP TO MULTIPLE VBPA_VBELN IN VBPA AS J3

DEFINE FILE LIKP
SHIPTO/A100 = IF VBPA_PARVW EQ 'WE' THEN VBPA_KUNNR ELSE '';
CARRIER/A100 = IF VBPA_PARVW EQ 'TU' THEN VBPA_LIFNR ELSE '';
END
TABLE FILE LIKP
PRINT
SHIPTO
CARRIER
BY VBPA_VBELN
WHERE VBUK_WBSTK = 'C'
AND VBPA_VBELN = '0000000051'
AND LIKP_WADAT FROM '20050101' TO '20070501'
END

and my output looks like

SD Doc. SHIPTO CARRIER
51......................
..........................
..........................
..........................700001
..........1000007



but I need

SD Doc. SHIPTO CARRIER
51 1000007 700001


The blank spaces occur because VBPA_PARVW has other values. If I do a sum instead of print, I am getting blanks.

SD Doc. SHIPTO CARRIER
51

Would

 
SUM
MAX.SHIPTO
MAX.CARRIER
BY VBPA_VBELN  

work to remove your blank spaces?

Kevin

How do you know that SHIPTO 1000007 and CARRIER 700001 belong to SD Doc. 51?

Ok, Max. did it.,that was easy. thanks Kevin.
Thanks Francis too for enquiring into this.