Table.InsertRows - Automate New Inserted Row to the maximum of the End Date|Power Query|Excel Forum|My Online Training Hub

Good Day Members,

I really have a tricky one here, either i am asking for the wrong solution or i simply need help with adding new rows.

Background Information:
This is an employee analysis report (excel) for a construction company which analysis both the Attendance (location & Duration) and Non-Attendance of their employees. The information comes for the in house built HR and Timekeeping System.

Both Absenteeism and Attendance are single transactions per day.
All forms of leave (sick; government processing ec cetera ) have a day quantity the transaction.

For the purpose of analysis and reporting, i require the quantity of leave to be transformed into a single transaction per day.
Then i will merge the Database Absenteeism; Attendance and Leave into a single table where all of this information will be analysed.

I would really appreciate your help with this as its consumes a lot of my time when the report is require it consumes about 3 hours of my time to put together...