Split a row in two when a column has 2 values

If you're working with a dataset where a single column contains multiple values, splitting those values into separate rows can significantly enhance clarity and usability. For instance, in your example, you have names paired with time ranges, but some entries include multiple time slots. The goal is to create a cleaner format that lists each name with its corresponding time slots on separate rows. While you've experimented with functions like LET and arrays, let's explore a more straightforward approach to achieve this outcome efficiently.