Adding Columns and Rows

[arzed0305]

Good day!

I would like to ask if this is possible.

I have one column with names on it and I would like to add another column beside it with dates from the first of the month until end of current month.

From this table:

Name

Employee 1

Employee 2

I would like to convert it to

Name           |     Date  

Employee 1       7/1/2022

Employee 1       7/2/2022

Employee 1       7/3/2022

Employee 1       7/4/2022

Employee 1       7/5/2022

Employee 1       7/6/2022

until end of month and this will be applied to Employee 1 and Employee 2.

Thank you in advance for any suggestions

[Jotigautam · Accepted solution]

@arzed0305 

This is possible with Generate rows. Check attached file.

[arzed0305]

Thank you this is amazing.

I just have a little issue, the last day of the month should be 7/31 but it ends at 7/30. 

May I ask if you could teach me how to edit the properties of the icon to show the accurate number of days in a month please?

Thank you

[arzed0305]

I was able to explore it.... Hehe

I am good with this one (^_^)

Thank you so much for the assistance.