Forum Discussion
Sudharshan1919
Helper III
3 years agoSplit of a Field Values
Hi All, Below format is my data. Date MachineName AssociatedUsers 1-Jan VM1 Usr1, Usr2, Usr5 2-Jan VM2 ...
v-zhangti
Community Support
3 years agoHi, Sudharshan1919
You can try the following methods.
First:
Result:
Second:
Make two more copies of the table, leaving one column of AssociatedUsers for each table. Replace the column names of the three tables with consistency.
Third:
Result:
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.