Mar 23 2022 11:09 AM
Hi, I have large data that has to be repeated based on the difference between start date and end date.
For example: I have a set of data already, I want to replicate the same data below for 60 times in each column below (considering start date as March 1st, 2022 and end date April 1,2022)
I really appreciate your help.
Mar 23 2022 11:16 AM - edited Mar 23 2022 11:17 AM
Create two custom lists: 1 for Emp ID and 1 for Name. This will allow you to drag the fill handle to fill out the items in a pattern. For the dates, select all dates in Start column and drag down as far as needed (Opt for 'Copy Cells'). Do the same for End date column.
Custom lists:
Create or delete a custom list for sorting and filling data (microsoft.com)
Mar 24 2022 02:19 AM