Forum Discussion

lalithab's avatar
lalithab
New Member
3 years ago

transform sub heading in power query

Unable to transform sub data in powerquery   
Need Help
lalithab's avatar
lalithab
New Member
3 years ago

 

 

I have a data like this with sub headings in a single sheet, i need to have them in PQ to sumarize how to convert the sub heading into a column

 

AlienSx's avatar
AlienSx
Super User
3 years ago

lalithab 

let
    Source = Excel.Workbook(File.Contents("full_path_to_file"), null, true),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Filtered Rows" = Table.SelectRows(Sheet1_Sheet, each ([Column2] <> null)),
    #"Promoted Headers" = Table.PromoteHeaders(#"Filtered Rows", [PromoteAllScalars=true]),
    #"Filtered Rows1" = Table.SelectRows(#"Promoted Headers", each ([Category] <> "Category"))
in
    #"Filtered Rows1"