Create single row based on column value

[wes11]

Good morning! I am attempting to create a single row of values based on the values in the WEEKDAY_RANGE column.  Please see image below.  Any ideas?

Thanks in advance!

[wes11]

@amitchandakThank you!

[amitchandak · Accepted solution]

@wes11 , first of all, add an index column by group : https://www.youtube.com/watch?v=7CqXdSEN2k4

Your group is weekday range.

I am expecting a new column to have 1 and 2.

Then Unpivot this new column hours

https://radacad.com/pivot-and-unpivot-with-power-bi