Each date has User ID, does anyone know how to clean this kind of data set? need help.

[Reinfresh123]

[wdx223_Daniel]

NewStep=Table.FromRecords(List.TransformMany(Table.ToRecords(PreviousStepName),each List.Zip({List.RemoveItems(Text.SplitAny([dates],"[]"","),{""}),Expression.Evaluate([user_id])}),(x,y)=>x&[dates=y{0},user_id=y{1}]))

[Reinfresh123]

hi! thankyou for the formula but do you have any simple ways? im just a beginner.