Append title at the end of a string

rajputakansha

Hi,

I have a column with same fields under different titles. I want to append the title names so as to differentiate them.

For example:

Input                               

ID

First Class

A

B

C

D

Second Class

A

B

C

Output

ID

A-First Class

B-First Class

C-First Class

D-First Class

A- Second Class

B-Second Class

C-Second Class

Is there a way to remove the headers and append it to the fields instead?

Thank you

benakesh

Hi @rajputakansha ,

If your data  follows  the  rule   "null followed by header "  this works . 

Append_Title1.yxmd