HI Guys!!
I need some extraordinary logic here...
Hope you can share yours..
scenario::
I have 2 fields:
field1 field2
1 a
2 b
3 c
2 d
1 a
3 e
I have two fields with respective values::
it seems simple but this is the problem.
I need to create a header wherein the value of field1 would be my first header then
the corresponding line item in field2 would be my second header. like this::
expected output::
1 2 3 <=field1 (if there are 3 same values let it be 1 avoid redundancy)
a a b d c e. <========field2 (second line corresponding values of field1 again if there are same values let it be 1 to avoid redundancy)
I dont know what kind of logic and coding would I be needing to achieve that.
I have 1 internal table w/c has field1 and field 2. everytime I sort field1 ,field2 is unsorted , vice versa.
Please experts , geeks!!ehehe..help me out!!!