dynamic rename

Question

Hi Guys,

I have a data of months and quantity in columns like

Month $Total $Month1 $Total1 $Month2 $Tota2 $Month3 $Total3 $1000500052006000100500200300

Now based on a condition like Month Name i would want Total $ column to be renamed as Month $ and likewise for all.

So like for first month I want Total to be replaced by month and followed by others. For next month I want tota1 to be replaced by month 1 and followed by others

Christine_Assaad · Answer

Hi @SouravKayal

Do I understand that you want - for example - Month1 and Total 1 to have same name, "Month 1" or your looking for the total column to show "Month 1 total"?

Perhaps a screenshot of what your desired output should look like, will help. Thanks!