Forum Discussion

klehar's avatar
klehar
Icon for Helper V rankHelper V
3 years ago
Solved

Split a row into many rows

Hi I have a dataset that looks like this   I want that every subject should be in its own row and not under respective names Note I cannot use Fill down as English and Science for Name = Rohan are...
Need Help
  • klehar's avatar
    klehar
    3 years ago

    Ahmedx i found the solution

    you have to use #(lf) for next line split

     

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WUtJRcs1Lz8kszlCK1YlWCsrPSMwDigUnZ6bmJaeCxYBc38QSiLxvfkZmCaZ8QEZlcWZyMZjrlZibWgzVAxSJBQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t, Subjects = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Subjects", type text}}),
    #"Replaced Value" = Table.ReplaceValue(#"Changed Type","",null,Replacer.ReplaceValue,{"Name"}),
    #"Filled Up" = Table.FillUp(#"Replaced Value",{"Name"})
in
    #"Filled Up"