This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Thanks for the clarification. This workflow uses a regex formula to split the input columns into Type and Day and then a text to columns to split the day numbers into rows
After that, it's a question of how you want the output. The top output is the most useful for further processing since [Day number] is a single numeric value that you can convert to a day name or a date. The second output includes the "Day" label in the [Day] field. the third output is similar to the output you included in the original post