I need to separate the columns, but everything is more complicated than it seems

Hello, I need help with one task. I need to separate the columns, but everything is more complicated than it seems.

For example, I extract two columns from the database, ColumnA and ColumnB.

The ColumnA includes the data with a code, and ColumnB includes the product code.

Here’s an example:

I need to split the data with “;” so that the output is a table like this:

How can I do this using KNIME nodes? Perhaps I could do this with just a Java Snippet node?