Split Weekday name and time hours in to different columns

[bhaskarpbi999]

Hi All,

I need your assitance to split the below data to different columns like Weekday in one column and Hours in one column.

Expected format either of the 2 below.

Thanks for your assistance..

[tharunkumarRTK · Accepted solution]

@bhaskarpbi999 
You can split your data first, Text.Split("Text", "#(lf)") and then expand the list into new rows and then split the column with ":" delimiter. Attached a sample for your reference. 

https://drive.google.com/file/d/1UzkpA9aohjDfwx8Sjnytox8bJJPdd5t2/view?usp=share_link 

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[bhaskarpbi999]

Thanks a lot for your assistance Tharun !