Hello Experts,
I have a data table that has multiple lines data in each cell (first line is check-in time and second line is check-out time). I want to convert the given data table into the expected format as shown below. I really have no ideal how to make it happen. Any help will be greatly appreciated. Excel formula is preferred.
![1736021701541.png 1736021701541.png](https://chandoo.org/forum/data/attachments/89/89648-a90d6dfc215a559820b0a2fce419a320.jpg)
A sample data file attached. Thanks.
I have a data table that has multiple lines data in each cell (first line is check-in time and second line is check-out time). I want to convert the given data table into the expected format as shown below. I really have no ideal how to make it happen. Any help will be greatly appreciated. Excel formula is preferred.
![1736021701541.png 1736021701541.png](https://chandoo.org/forum/data/attachments/89/89648-a90d6dfc215a559820b0a2fce419a320.jpg)
A sample data file attached. Thanks.
Attachments
Last edited: