modify table row values

[df123445]

I have 2 tables,  Master and modifier:

Master:

Product	main indication	secondary indication
ABC	N/A	N/A
EFG	disinfectant	soap

Modifier:

Product	new primary indication	new secondary indication
ABC	weedkiller	water flavoring
ABC	rat poison	ambient fragrance

Is there a way to combine the values in the Master table:

Product	main indication	secondary indication
ABC	weedkiller	water flavoring
ABC	rat poison	ambient fragrance
EFG	disinfectant	soap

I'm basically looking for a way to update my master table infos based on a temporary table that holds the updated info.

TIA 

[Bmejia]

You can append the Master table to the Modifier table during transformation.

Just make sure that both column headers have the same name otherwise it's going to be added in a separate column.
For example in the Master table you have "Main Indicator" you would need to renamed to "Primary Indicator" or vise versa.  Then append the tables. Note It will bring ABC N/A  as a different row.   you will have to filter it out if you don't need it base on your conditions.