Replace whole row?

[rogersm01]

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]

Hi @rogersm01 

You dont have to do for each column spereately.

Make use of the multi field formula to achieve the output.

Many thanks

Shanker V

[ShankerV · Accepted solution]

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 solution]

Hi @rogersm01, 

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

Hope this helps

[rogersm01]

thanks for responses - really appreciated