Forum Discussion

Nightstrand's avatar
Nightstrand
Copper Contributor
May 04, 2024

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.