Detection of bold characters

[omar_bk95]

Hello everyone,

I am trying to transform my table from the left hand side to the right hand side using transformations on Alteryx. I am still new and learning how to manipulate data. The motivation behind this transformation is to improve the regrouping of different 'subtitles' which I called 'normal title'.

I have attached the files to make it easier for the helpers.

[atcodedog05 · Accepted solution]

Hi @omar_bk95 

I hope this what you are looking for.

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[omar_bk95]

Thank you! 
I might ask few questions because the IIF conditions look a bit specific and I have a general table but i will work it out from here.

[atcodedog05]

Happy to help 🙂 @omar_bk95 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂