How to get a data field from a different row and retrieve it to another row corresponding to a data?

[Mohamadmonem]

Hello Experts,

I would like to get a particular data from a different row and retrieve it to another row corresponding to a data. Let me explain it:

Assume that I have  a column (A). the column A has differrnt data (values) within different rows. 

I would like to create a new column (for example column New) and retrieve the different values of the column A in my new column based on a shared value from column B.

How to do that? 

something like that:

Column A    ColumnB     New Column

Row1: x1      y                        x2

Row2: x2      y                        x4

.

.

.

Row3=xn    y

Thanks in adavnce

[Mohamadmonem · Accepted solution]

I have my own idea for that,a and it worked for me.

I got the same datasource again and created a connection between two tables. then, I used the lookup function in the first table and retrieved my intended data. 

[Mohamadmonem]

Does anyone know?

Thanks in advance.

[VijayP]

@Mohamadmonem  Still unable to understand the problem statement, provide some sample data with final expected outcome

[Mohamadmonem]

Thanks for your kind reply;

I would like to get y3 from row3 based on x1 (which is common data among the rows) and retrieve it in a new column in the row 1. How to do that? Of course this is simple. I would like to write a function to do for all of my rows. 

ColumnA	ColumnB	new column
y1	x1	y2
y2	x1
y3	x1