March 10, 2025
HansV MVP - Ashish Mathur - Andreas Killer - Bob Jones AKA: CyberTaz - Jeovany CV ✅
Ask a new question
Hi Experts,
Would like to know how to identify sub header in power query. i'm looking for solution below
Hi,
This M code works
let
Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
#"Added Custom" = Table.AddColumn(Source, "Category", each if [Price]=null then [Product] else null),
#"Filled Down" = Table.FillDown(#"Added Custom",{"Category"}),
#"Filtered Rows" = Table.SelectRows(#"Filled Down", each ([Price] <> null)),
#"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows",{{"Price", type number}})
in
#"Changed Type"
Hope this helps.
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
Thanks for your feedback.