Hello all,
I am wondering if it will be possible to split values from a list to working days.
Document i have: List of over 100 individuals with the total working days in a month.
Document i want: List of those 100 individuals split over working days of a certain month and the total working days split over that period.
I am using latest version of excel and have Power Bi as well if needed.
Example:
What i have
| Person A | 15 |
| Person B | 20 |
| Person C | 18 |
Example:
What i want
| Person A | 01/06/2022 (DD/MM/YYYY) | 1 |
| Person A | 02/06/2022 | 1 |
| Person A | 03/06/2022 | 1 |
| Person A | 05/06/2022 | 1 |
| Person A | etc | etc until the total working days is filled. |
| Person B | 01/06/2022 | 1 |
| | 02/06/2022 | 1 |
| | 03/06/2022 | 1 |
| | 05/06/2022 | 1 |
| etc | | etc until the total working days is filled. |
