how to capture data in another record within 2 records

[isaactong]

Hi all,

I have a case need your help that:

- 2 records with same unique key (e.g. user ID) only different in "type" column (i.e. BUY/SELL)

- both 2 records have same column called "DISPLAY"

- how I can capture the data in "DISPLAY" column of 2nd record to 1st record at "opposite display" column and then

- capture the data in "DISPLAY" column of 1st record to 2nd record at "opposite display" column

- pls see example as below 

user ID	type	display	opposite display
123456	buy	Yes	No
123456	sell	No	Yes

Many thanks in advance

[alexnajm]

Sounds just like a normal Formula to get the Opposite Display?

IF [Display] = “Yes” THEN “No” ELSE “Yes” ENDIF

[isaactong]

Thanks,

but how is the workflow to capture the record in "display" column of 2nd row to "opposite display" column at 1st row?

user ID	type	display	opposite display
123456	buy	Yes	No
123456	sell	No	Yes

[binuacs · Accepted solution]

@isaactong 

[isaactong · Accepted solution]

many thanks binuacs,

It is working and thanks a lot for your help