Forum Discussion
Helper VSplit Weekday name and time hours in to different columns
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_linkIf 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
Super Userbhaskarpbi999
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
bhaskarpbi999Thanks a lot for your assistance Tharun !