Transform data set with parent and child value

Question

Hello,&nbsp;I have a table with hiearachy structure&nbsp; like parent and child value .(Excel file)EntitéDIR&nbsp;effectStagInfenedisdsiServE6&nbsp;6&nbsp;dfaaservA1019&nbsp;&nbsp;ServB27324&nbsp;DCTServC11&nbsp;&nbsp;&nbsp;ServD12&nbsp;12&nbsp;&nbsp;ServE523edfedf1serv13&nbsp;&nbsp;&nbsp;&nbsp;serv24&nbsp;&nbsp;&nbsp;edf2serv 36&nbsp;&nbsp;&nbsp;&nbsp;serv22&nbsp;&nbsp;How can i use power query to automate the duplicate of each parent value in the table and have this :EntitéDIR&nbsp;effectStagInfenedisdsiServE6&nbsp;6enedisdfaaservA1019enedisdfaaServB27324enedisDCTServC11&nbsp;enedisDCTServD12&nbsp;12enedisDCTServE523edfedf1&nbsp;&nbsp;&nbsp;&nbsp;edfedf1serv13&nbsp;&nbsp;edfedf1serv24&nbsp;&nbsp;edfedf2serv36&nbsp;&nbsp;edfedf2serv22&nbsp;&nbsp;Thank you for your help!

ba_pete · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Select your [Entite] column, go to the Transform tab &gt; Fill &gt; Down.
&nbsp;
Pete

Forum Discussion

Transform data set with parent and child value

1 Reply

Related content

Parent/child hierarchy creation

Power Query - flatten Parent-child hierarchy

Parent pipeline invokes old version of child pipeline until parent is re-saved

Dax measure parent/child

Parent/Child Hierarchies visual with multiple parents

Entité	DIR		effect	Stag	Inf
enedis	dsi	ServE	6		6
	dfaa	servA	10	1	9
		ServB	27	3	24
	DCT	ServC	1	1
		ServD	12		12
		ServE	5	2	3
edf	edf1	serv1	3
		serv2	4
	edf2	serv 3	6
		serv2	2