Is there a way to take data from one sheet and transpose it into another sheet.

[Nightstrand]

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. 

[#2]

@Nightstrand 

=LET(
    clockin,  IFERROR(MOD(TEXTBEFORE(clockData, "-"), 1), "Off"),
    clockout, MOD(TEXTAFTER(clockData, "-"), 1),
    adjusted, N(clockout < clockin),
    IFERROR(
        HSTACK(
            name,
            clockin,
            (timeline >= clockin) * (timeline <= clockout + adjusted)
        ),
        ""
    )
)

giving

[#3]

@Nightstrand 

[#4]

@Peter Bartholomew 

Thank you for looking at this for me, I'll put your code into my spreadsheet and see if I can get it working