How to remove underscore in title line

[gongyunqian622]

Hi,

I try to use crosstab to use column Name be my title line, however, after I did it, it show underscores among each words. How to fix it? I only want to show for example 01-Apple pie as my title. Thank you!

[christine_assaad · Accepted solution]

Hi @gongyunqian622 

I can't open your Excel file but basically, you need to add a Dynamic rename to remove the "_" like in the below screenshot. Cheers!

[JakobJ]

Thanks this helped a ton!