Adding Text to the end of rows of 1st column from a field or different table for Excel

[JKFoil]

Hello 

Some help please.

I need to put some text derived from the table after the last row on the 1st column.  Either from the same table or another table. Please see mock up example below. I have managed to create the required text with a workflow.

Table 1
Field 1	Field 2	Field 3	End Calc		End Calc
Dave	3	Happy	Name-End00000004		Name-End00000004
John	4	Sad	Name-End00000004
Paul	6	Sad	Name-End00000004
Sue	7	Happy	Name-End00000004
Name-End00000004

[Emil_Kos · Accepted solution]

Hi @JKFoil,

You can use union tool to achieve it:

The output:

[JKFoil]

Thank you Emil

Worked perfect. I tried this but missed off changing to Auto Config by position.