How to duplicate rows based on two columns?

[mtrevisiol]

Hi everyone,

I've got a table that represents the hours of work of some employees.

It contains the name of the employee, the start date and time and the end date and time:

My intent is to duplicate each row to obtain a row containing the starting date and a row containing the ending date of each employee, something like this:

Because my intent is to create a relation between Table.DateStart and the Calendar Table. Do you know how can I do it, using Power Query? Thank you so much.

[freginier]

In Power Query :

- Merge DataStart and DataEnd into one column with pipe ("|") delimiter for example

- Split this column on row (not column)

You should get what you want

[mtrevisiol]

@freginier thank you so much, it works!

But I have another problem: if I wanted to "split" only the rows where DataStart is different from DataEnd?

The ideal result would be this:

Thanks.

[freginier · Accepted solution]

So before merging column create conditional column to check if DataStart <> DataEnd if true then merge : DataStart & "|" & DataEnd else null 

And now split this conditional column !

[mtrevisiol]

@freginier  thank you so much!