Forum Discussion

jonbox's avatar
jonbox
Helper II
3 years ago
Solved

Extract content from rows

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 IDException NameRelated Issues
Ex-1Example 1

Issue-0001

Issue-0002

Issue-0003

Ex-2Example 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 NameRelated Issues
Ex-1Example 1Issue-0001
Ex-1Example 1Issue-0002
Ex-1Example 1Issue-0003
Ex-2Example 2Issue-0004
Ex-2Example 2Issue-0005

 

Any help would be much appreciated!

 

Thank you!

  • 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.

     

     

     

     

1 Reply

  • ddpl's avatar
    ddpl
    Solution Sage

    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.