Append Field by joining data from same source

[timewaste]

Hi Peers,

Newbie here. How can I accomplish this? The data in column E should be same as data in column A. TIA!

Source Sheet (for both sources - columns A,B,C,D and E): 

A	B	C	D
1	b1	c1	d1
2	b2	c2	d2
3	b3	c3	d3

Target Sheet:

A	B	C	D	E
1	b1	c1	d1	1
2	b2	c2	d2	2
3	b3	c3	d3	3

Workflow:

[JoshKushner]

A join should get you what you need

Flow:

  

Results:

Join:

[JoshKushner · Accepted solution]

Or if you're saying how do you create column E from a single input that has columns A-D then use the formula tool to create a new column equivalent to A:

Flow:

Results:

Formula:

[timewaste]

Thanks once again!