Forum Discussion

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 appear...

excel

PeterBartholomew1

Silver Contributor

May 04, 2024

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