Hi All,
I have excel with the below details, Would want to have the transformed output as mentioned, please can someone guide what are the steps can be followed in power automate to get the output.
| ID | Employee Name | 02-01-2023 | 09-01-2023 | 16-01-2023 | 23-01-2023 | 30-01-2023 | 06-02-2023 | 13-02-2023 | 20-02-2023 |
| 1 | ABC | 1 | 2 | 6 | 5 | 1 | | | |
| 2 | XYZ | | | | | | 4 | 5 | 3 |
Output
| ID | Employee Name | Month | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |
| 1 | ABC | Jan | 1 | 2 | 6 | 5 | 1 |
| 2 | XYZ | Feb | 4 | 5 | 3 | | |
