Grouping week category based on date

[SH_94]

Dear community,

I have data as per screenshot below and would like to ask how can i convert the data to the result below:

Basically i would like to transform the column C and produce different result as per screenshot below.

Original

Output

Many thanks for the help.

[atcodedog05]

Hi @SH_94 

Here is how you can do it.

Workflow:

Hope this helps : )

[SH_94]

Hi @atcodedog05 ,

Many thanks for the prompt response.

I would like to ask how can we create the formula to resolve the issue below if we have the sequence not in order.

Many thansk again for the help.

[Qiu]

@SH_94 
based on the flow of @atcodedog05 , I just added a sorting process.

[atcodedog05 · Accepted solution]

Hi @SH_94 

Here is my take on it.

Workflow:

Hope this helps : )

[atcodedog05]

Happy to help : ) @SH_94 

Cheers and have a nice day!