Forum Discussion
mtrevisiol
Helper V
4 years agoHow 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...
- 4 years ago
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 !
freginier
Solution Sage
4 years agoSo 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
Helper V
4 years agofreginier thank you so much!