dynamic rename

[SouravKayal]

Hi Guys, 

I have a data of months and quantity in columns like 

Month $	Total $	Month1 $	Total1 $	Month2 $	Tota2 $	Month3 $	Total3 $
1000	5000	5200	6000	100	500	200	300

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]

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!