Replace whole row?

Question

Hi - I want to replace the word Spend with Expenditure in the following report:

Do I have to replace in each column individually or can this just be done for row 'Advertiser'?

At the moment, this runs through a macro that takes an age to run and ultimately comes out like this:

thanks.

ShankerV · Accepted Answer

i @rogersm01

Please find the expected output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

FinnCharlton · Accepted Answer

Hi @rogersm01,

Here is the configuration of the multi-field tool that you will need to use:

Hope this helps