I am having the data like below,
ID TASK_NAME TASK_OWNER OWNER2
1 Task_one Miller John;Peter
2 Task_two Tom James;Laura;Denise
I am looking for the output like below,
ID TASK_NAME OWNER
1 Task_one Miller
1 Task_one John
1 Task_one Peter
2 Task_two Tom
2 Task_two James
2 Task_two Laura
2 Task_two Denise
I have modified the input and output....
Is there any chance this can be achieved through Query.