Forum Discussion

CostaBella's avatar
CostaBella
Frequent Visitor
3 years ago
Solved

Remove 2nd Header In Power Query Editor

I have a yearly report that I am working on. It pulls a list of any construction projects that are located on a hurricane evacuation route. The problem is that the data I am connecting to is somehow ...
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Potential simple fix would be to filter Contract ID to exclude "Contract ID" as I doubt you'll have an ID of that and if it starts to appear multiple times (guessing your source data has it across multiple pages or something) as you data grows it will remove every occurance of "Contract ID".

     

    = Table.SelectRows(#"Changed Type", each ([Contract ID] <> " Contract ID"))

     

    Thanks,

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Potential simple fix would be to filter Contract ID to exclude "Contract ID" as I doubt you'll have an ID of that and if it starts to appear multiple times (guessing your source data has it across multiple pages or something) as you data grows it will remove every occurance of "Contract ID".

 

= Table.SelectRows(#"Changed Type", each ([Contract ID] <> " Contract ID"))

 

Thanks,

CostaBella's avatar
CostaBella
Frequent Visitor
3 years ago

I have been working in Power Query Editor for a little over a year now (by no means an expert) and I am upset that I did not think of this. Thank you for simplifying it for me! I guess I was just overthinking it.