Forum Discussion
mtrevisiol
Helper V
Helper VHow to duplicate rows based on two columns?
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...
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 !
mtrevisiolHelper V
Helper Vfreginier 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
Solution Sage
Solution SageSo 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!