Extract content from rows

[jonbox]

Hi, 

I'm trying to extract and duplicate rows based on the content of a particular column;

I'm not sure how i can achieve this... I've tried using the extract functionality but this doesn't seem to work...

The below table is what my data currently looks like:

Exception ID	Exception Name	Related Issues
Ex-1	Example 1	Issue-0001 Issue-0002 Issue-0003
Ex-2	Example 2	Issue-0004 Issue-0005

This is what i want it to look like. You can see the related issues have been extracted and the rows duplicated.

Exception ID	Exception Name	Related Issues
Ex-1	Example 1	Issue-0001
Ex-1	Example 1	Issue-0002
Ex-1	Example 1	Issue-0003
Ex-2	Example 2	Issue-0004
Ex-2	Example 2	Issue-0005

Any help would be much appreciated!

Thank you!

[ddpl · Accepted solution]

@jonbox try below

1.First replace the blank value with null value by selecting both the column.

2.Second select both the column and fill down the data as per below snap.