Reports

Blacklisted phrase (0.5): how can I
Blacklisted phrase (3): kindly help
Long answer (-1):
Has code block (-0.5):
Self-answer (0.5):
Low reputation (1):

In my advanced editor already has the code below:

let
    Source = Excel.Workbook(File.Contents(myfile), null, true),
    #"Eqp-list new_Sheet" = Source{[Item="Eqp-list new",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",),
    #"Removed Top Rows" = Table.Skip(#"Changed Type",1),
    #"Promoted Headers1" = Table.PromoteHeaders(#"Removed Top Rows", [PromoteAllScalars=true]),
    #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers1),
    #"Added Index" = Table.AddIndexColumn(#"Changed Type1", "Index", 1, 1, Int64.Type),
    #"Reordered Columns" = Table.ReorderColumns(),
    #"Duplicated Column" = Table.DuplicateColumn(),
    #"Extracted Text After Delimiter" = Table.TransformColumns(),
    #"Reordered Columns1" = Table.ReorderColumns(),
    #"Renamed Columns" = Table.RenameColumns(),
    #"Reordered Columns2" = Table.ReorderColumns(),
    #"Renamed Columns1" = Table.RenameColumns(),
    #"Reordered Columns3" = Table.ReorderColumns(),
    #"Renamed Columns2" = Table.RenameColumns(),
    #"Reordered Columns4" = Table.ReorderColumns(),
    #"Duplicated Column1" = Table.DuplicateColumn(),
    #"Added Custom" = Table.AddColumn(),
    #"Removed Columns" = Table.RemoveColumns(),
    #"Reordered Columns5" = Table.ReorderColumns(),
    #"Replaced Value" = Table.ReplaceValue(),
    #"Added Custom1" = Table.AddColumn(),
    #"Added Custom2" = Table.AddColumn(),
    #"Added Custom3" = Table.AddColumn(),
    #"Added Custom4" = Table.AddColumn(),
    #"Added Custom5" = Table.AddColumn() in
    #"Added Custom5"

...they come from the steps I did before I reached to the step where I have to separate the row. Not sure how can I add the new code into it. Please kindly help.

Blockquote

79391269