Split words from a String

[ankit0412]

Hello,

How can I splits Days column into 5 different columns as below

Thank You

Days	Mon	Tue	Wed	Thr	Fri
M	M
MT	M	T
MTW	M	T	W
MTWR	M	T	W	R
MTWRF	M	T	W	R	F

[Gaurav_Dhama_]

You need to split the word into rows and then cross tab them to get back the tabular data. Attached is the workflow demonstrating the same.

[Qiu]

@ankit0412 
How about we directly split the string to 5 columns.

[binu_acs · Accepted solution]

@ankit0412 one way of doing this

[aatalai]

@ankit0412 another way would be using the formula tool and if contains e.g

IIF(Contains([Days], "M"), "M", null())