Arrange Data: Get unique combination of Month and Week

[Hudas]

Hi -

I've modified my post to incude the attachment.

So here's my problem,
I have in Column A List of months and in Column B a Week number for each month. Month is repeated any number of times depending on the frequency of the week, there can also be multiple week under the same month. So basically I'm gonna need to arrange the data to reflect one combination for each month and each week. Please see attached sample data.

Thank you

[watersev]

hi Hudas, option to make it, please check attachment, run code "test"

[Hudas]

Hi - First of all Thank you very much !!

I've checked your code and the result, but it seems that it overwrited the original data... would you be so kind in transferring the data unto another sheet instead of overwriting the original data?

[watersev]

please check attachment