Hi Experts,
I have fields [DateEntered] and [Objective] in Table1 as following.
Table1
DateEntered Objective
1/2/2016 Objective 1, Objective 2, Objective 3
I need to automatically split data in the [objective] field by each comma (,). The resultant table (assume Table2) should...