I have a table with concatenated error messages similar to this.
| Customer ID | Error messages |
|---|---|
| 1 | missing_surname; |
| 2 | missing_surname; missing_address; |
| 3 | missing_surname; missing_address; missing_tel; |
I need to split the error messages so that each error message is on a single row and the customer ID is duplicated if the customer has more than one error.
I’ve looked at splitting the error messages but that just splits vertically.
| Customer ID | Error messages |
|---|---|
| 1 | missing_surname; |
| 2 | missing_surname; |
| 2 | missing_address; |
| 3 | missing_surname; |
| 3 | missing_address; |
| 3 | missing_tel; |
New contributor
Monju Begum is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.