Replacing the text from particular column.

[Myusrename001]

Hi Team,

I wanted to add rate to a particular column and it should be aligned / tag to %. These % will keeps on changing based on the individual account. Below is the example needed your guidance. Thanks in advance.

 Before 

Header
25%	15%	12.80%	10%	rate
				12.8	MY Data Set
				25
				25
				25
				25
	15			15

After

Header
25%	15%	12.80%	10%	WHT rate
		12.8		12.8	MY Data Set
25				25
25				25
25				25
25				25
	15			15

[IraWatt · Accepted solution]

Hey @Myusrename001,

Here's one way of doing this:

Its dynamic so should adjust if you add in more rates or columns.

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com  

[Myusrename001]

Thanks @IraWatt 

[IraWatt]

No worries @Myusrename001 😄