Is there a way to take data from one sheet and transpose it into another sheet.
Good morning,
I am trying to take the data that I can copy and paste into excel in this format from a HR system.
And place the name and the start and end times into a sheet that appears like the below.
I want the name to auto populate and likewise if a start time from the top table is 0700 and end time is 1900 I want the formulas to identify that and fill it in with the letter A. Then remain blank if they are not working at that time.
Good morning, I am trying to take the data that I can copy and paste into excel in this format from a HR system. And place the name and the start and end times into a sheet that appears like the below. I want the name to auto populate and likewise if a start time from the top table is 0700 and end time is 1900 I want the formulas to identify that and fill it in with the letter A. Then remain blank if they are not working at that time. Read More
