Split or Trim Rows Based on Certain Criteria

Hi RahulPBI 

Try this,

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("PctNCoAgEAbQq3y4jvJnxtqm0CahsMCFeP9rNFK0frxaVTrZIXo9BlDBrFe4XbWhqqtD9izgfIL9lF7dbiZkMUsJtJTJ8T+PaDXWEEWNRYIR7pWF2wM=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Text = _t]),
    #"Added Custom" = Table.AddColumn( Source, "Custom", each 
        let 
            split = Text.SplitAny( [Text], " /"  ),
            xxx = [
                column1 = 
                    List.Select( 
                        split, 
                        (i) =>     
                            List.Contains( { "A".."Z" }, Text.Start( i, 1 ) ) 
                            and List.Contains( { "0".."9" }, Text.End( i, 1 ) ) 
                    ){0},
                column2 =
                    List.Select( 
                        split, 
                        (i) => Text.EndsWith( i, ".B" ) 
                    ){0},
                column3 =
                    try List.Select( 
                        split, 
                        (i) => Text.EndsWith( i, "L" ) 
                    ){0} otherwise null,
                column4 =
                    List.Select( 
                        split, 
                        (i) => Text.EndsWith( i, "W" ) 
                    ){0},
                column5 =
                    List.Select( 
                        split, 
                        (i) => Text.EndsWith( i, "A" ) 
                    ){0},
                column6 =
                    List.Select( 
                        split, 
                        (i) => Text.EndsWith( Text.Upper( i ), "K" ) 
                    ){0}
            ] 
            
        in xxx

      
    ),
    #"Expanded Custom" = Table.ExpandRecordColumn(#"Added Custom", "Custom", {"column1", "column2", "column3", "column4", "column5", "column6"}, {"column1", "column2", "column3", "column4", "column5", "column6"})
in
    #"Expanded Custom"