Sort and copy with excel only

[harjotsingh87]

Hello friends,

I am looking for an excel formula that will help me perform below function:

Pick values from first column based on second column and put the values in the respective areas highlighted in orange. I can do this in VBA but VBA is not allowed in our office so looking for excel function that can do this.

Thanks in advance,
Harjot

 

[harjotsingh87]

Couldn't copy the image, below is the table that I want to create.

a	Realized		Unrealized		Realized
b	Unrealized		b		a
c	Realized		d		c
d	Unrealized		e		f
e	Unrealized		g		i
f	Realized		h
g	Unrealized		j
h	Unrealized
i	Realized
j	Unrealized

<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>

Hello friends,

I am looking for an excel formula that will help me perform below function:

Pick values from first column based on second column and put the values in the respective areas highlighted in orange. I can do this in VBA but VBA is not allowed in our office so looking for excel function that can do this.

Thanks in advance,
Harjot

 

[harjotsingh87]

Friends, please suggest if its possible to do it with combination of excel formulas?