Split date Columns in multiple rows

[murfada]

I have date column and i want split it in multiple row as below

I woul

Year

2019

2020

2021

01-Jan-2022 to 31-May-2022

01-Jun-2022 to 31-May-2023

1-Jun-2023 to   07-Nov-2023

[v-stephen-msft]

Hi @murfada ,

It seems that your post is not finished. What does your data look like, and what does the final expected result look like?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.