Skip to Content
0
Former Member
Sep 13, 2007 at 06:41 AM

Simple yet complicated

26 Views

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!!!