Drill down Rows

[Addora]

Hello there,

please, I ask for some support at Power BI, I'm new at that fabulous application. I got data from a XML file >> then edit >> as shown I ask for how can I drill or split each line in an autonomy row then fill down the other rows, is that applicable in Power BI, I hope that, please

 

[ralliartur]

I don't know if i've understood correctly the request, but i can propose this:

My table:

[TABLE="width: 500"]
<tbody>[TR]
[TD]aaa[/TD]
[/TR]
[TR]
[TD]Header
1 Line1
2 Line2
3 Line3[/TD]
[/TR]
</tbody>[/TABLE]


In power query:

let    
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Transformation = Table.AddColumn(Source, "ToRows", each Table.PromoteHeaders(Table.FromList(Text.Split([aaa],("#(lf)")))))
in
    Transformation

At the end:

[TABLE="width: 500"]
<tbody>[TR]
[TD]aaa[/TD]
[TD]ToRows[/TD]
[/TR]
[TR]
[TD]Header
1 Line1
2 Line2
3 Line3[/TD]
[TD]Table[/TD]
[/TR]
</tbody>[/TABLE]


ToRows column contains:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Header[/TD]
[/TR]
[TR]
[TD]1 Line1[/TD]
[/TR]
[TR]
[TD]2 Line2[/TD]
[/TR]
[TR]
[TD]3 Line3[/TD]
[/TR]
</tbody>[/TABLE]

 

[MarcelBeug]

My proposal:

let
    Source = Excel.CurrentWorkbook(){[Name="MultipleLineTable"]}[Content],
    MultipleLineTable = Table.TransformColumnTypes(Source,{{"Column with lines", type text}, {"Other column1", type text}, {"Other column2", type text}}),
    LinesFromText = Table.TransformColumns(MultipleLineTable,{{"Column with lines", Lines.FromText, type text}}),
    Expanded = Table.ExpandListColumn(LinesFromText, "Column with lines")
in
    Expanded