Generate a new column with row values

*Hello Knimers : D*. I hope you´re doing great.

So I´m facing a new problem here and I don´t have any idea how to deal with it.

I have a table that is a pivoting result:

“Employee Activity” column has different values, and those values has its own date & time value.

I´m looking for a way to “Separate” or “Split” all the values of “Employee Activity” column. my expected output is something like this:

Generate new columns with the separated values and, using the same ID

Things I´ve tried:

• Pivoting this table

• Unpivot

• Column splitter

Thanks in advance

• N