Forum Discussion
Solved
Create single row based on column value
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 , 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
amitchandakThank you!