Hi @Marksdasjkv ,
Try this query:
;with cte as
(
select *,ROW_NUMBER()over(partition by Date,[win/loss] order by Date) as rn from team
)
select * from cte pivot(max(rn)for [win/loss] in (win,loss))as pvt
Best regards,
Niko
----------
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.