Append new values

[samxhander09]

Hi, I have two tables with similar values. Example, table 1(template table) and Table 2 both have Area Code,  however, the number of rows are not the same. I tried to use Find and Replace Tool, but it only returns the first match. For your reference, im attching pictures and sample workflow. Hope you can help me.

Table 1 (This is the template table)

Table 2 (this has values for Charge per HR and CGP which I need to append to Table 1 using their respective Area Code)

Table 3 (basically table 1 but now with values for Charge per hour and CGP) ps: All blanks will be set to 0 value

[Qiu · Accepted solution]

@samxhander09 
I use the Tile tool to predefine the Stack Order and put the data together.

[samxhander09]

@Qiu it looks good, my friend. thank you for helping and teaching me about a new tool(new to me)!