How to split data cell?

[hmfa]

Hi @Is_celine
Use cell splitter with \n splitter char and list output and ungroup de list

You can then follow @alpayzeybek solution.

Extract word ( string splitter (regex) node)

Hi @Jia_Qi Would it be possible for you to upload the data file you’re referring to? That way, we can experiment with it directly and help structure the data exactly the way you’re aiming for. In the meantime, based on the structure visible on the screen, I’ve built a preliminary KNIME flow that formats the data as I believe you intended. It includes: Realignment of the driver name and status columns Proper mapping of license expiry dates Clean-up of any structural inconsistencies Please …

Best Regards