Forum Discussion
Solved
[Power Query] Split rows into columns, but with some conditions
Hi, I want to split rows according to screenshot (sorry for limited description, but it's easier to show on graphic than describe the problem). In the table I have few rows like in "Input Da...
Hi knyklu
One way:
let Source = Excel.CurrentWorkbook(){[Name="Table"]}[Content], NullREP = Table.ReplaceValue(Source, each [REP], null, (x,y,z) as list => {null} & Text.Split(y, ";"), {"REP"} ), ExpandedRep = Table.ExpandListColumn(NullREP, "REP"), UpdatedEtap = Table.ReplaceValue(ExpandedRep, each [Etap], each [REP], (x,y,z) as nullable text => if z is null then y else null, {"Etap"} ) in UpdatedEtap
Hi knyklu
One way:
let
Source = Excel.CurrentWorkbook(){[Name="Table"]}[Content],
NullREP = Table.ReplaceValue(Source, each [REP], null,
(x,y,z) as list => {null} & Text.Split(y, ";"),
{"REP"}
),
ExpandedRep = Table.ExpandListColumn(NullREP, "REP"),
UpdatedEtap = Table.ReplaceValue(ExpandedRep, each [Etap], each [REP],
(x,y,z) as nullable text => if z is null then y else null,
{"Etap"}
)
in
UpdatedEtap