cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jonbox
Helper II
Helper II

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!

1 ACCEPTED SOLUTION
ddpl
Solution Sage
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.

 

ddpl_1-1669809576229.png

 

 

 

View solution in original post

1 REPLY 1
ddpl
Solution Sage
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.

 

ddpl_1-1669809576229.png

 

 

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.