Formula for Output columns

ashleyinman

I have data input in multiple columns where I want to reformat to show only the data i need.

Below i have the data currently being input and what I would like to see after i do some formulas but I'm not sure how to get to my desired outcome. 

I need the accept and reject dates but I need the deliver type created by person/ 

This is what is currently being input
Accept/Reject Date	Transaction Date	Item	Qty	Location	Created by	Type
6/11/2019	6/12/2019	ABC	100	Review	1	Accept
6/12/2019	6/12/2019	ABC	100	Review	2	Deliver
6/3/2019	6/3/2019	EFG	500	Over	3	Reject
6/3/2019	6/3/2019	EFG	500	Over	4	Deliver
This is what I want output
Accept/Reject Date	Transaction Date	Item	Qty	Location	Created by	Type
6/11/2019	6/12/2019	ABC	100	Review	2	Accept
6/3/2019	6/3/2019	EFG	500	Over	4	Reject

afv2688

Hello @ashleyinman ,

Hope this helps.

Results are shown in the join tool

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

transactions.yxmd