Need formula to filter student information based on a condition of getting subject mark less than 50

ajl_ahmed 

Nope, that is separate tool within Excel About Power Query in Excel (microsoft.com)

Hi ajl_ahmed 

https://www.bing.com/search?q=What+is+Power+Query

Another Power Query option attached. Query code (edited):

let
    Source = Excel.CurrentWorkbook(),
    CombinedTables = Table.Combine(
        List.Transform({"1".."2"}, each 
            let
                table = Source{[Name="range"&_]}[Content],
                source = Table.PromoteHeaders(Table.Skip(table), [PromoteScalars=true]),
                stage = Table.AddColumn(source, "Stage", each Table.First(table)[Column4])
            in Table.AddColumn(stage, "Semester", each Table.First(table)[Column2])
        )
    ),
    UnpivotedOtherColumns = Table.UnpivotOtherColumns(CombinedTables,
        {"Name", "Stage", "Semester"}, "Subject", "Value"
    ),
    FilteredRows = Table.SelectRows(UnpivotedOtherColumns, each [Value] < 50),
    RemovedColumn = Table.RemoveColumns(FilteredRows,{"Value"})
in
    RemovedColumn