Split values from a field and create rows for each value

[Max]

This is something that cannot be accomplished with a calculated field. Calculated fields are only calculations that happen at the row level (i.e they can’t create rows).

If you are using athena, you can run a split and cross join.

https://prestodb.io/docs/current/functions/string.html

https://prestodb.io/docs/current/sql/select.html#cross-join